CODEWITHSUNDEEP
mysqlr
Sanky Ach
Sanky Ach

Reputation: 335

unable to find an inherited method for function ‘dbReadTable’ for signature ‘"character", "missing"’

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")

Upvotes: 4

Views: 3640

Answers (1)

koltorex
koltorex

Reputation: 64

the DBIConnection is missing 

dbReadTable(mydb,"table_name")

Upvotes: 4

Related Questions