Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- library(RMySQL)
- library(DBI)
- con = dbConnect(MySQL(),
- user="root", password="rey13",
- dbname="reydata", host="localhost")
- dbListTables(con)
- resut=dbSendQuery(con,"select * from students")
- data.students=fetch(resut,n=3)
- print(data.students)
- *******************************************************
- 'contacts' 'students'
- Warning message in .local(conn, statement, ...):
- "Unsigned INTEGER in col 0 imported as numeric"
- id_student name_student surname_student email
- 1 1 rey montero rey@domain.com
- 2 2 noela claire garcia claire@domain.com
- 3 3 mark joseph garcia markjoseph@domain.com
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement