I am trying to read the table data in R with MySQL package.
Getting error: unable to find an inherited method for function ‘dbReadTable’ for signature ‘"character", "missing"’
code:
library(RMySQL)
library(dbConnect)
mydb = dbConnect(MySQL(), user='user',
password='password', dbname='blank_copy',
host='ip address', port = port_number)
dbListTables(mydb)
dbListFields(mydb, 'SELECT * FROM table_name')
dbReadTable("table_name")
the DBIConnection is missing
dbReadTable(mydb,"table_name")
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With