MySQL query in R to compare with certain value [duplicate]

Question

 args <- commandArgs(trailingOnly = TRUE)
 id = as.character(args)
 mysqlconnection = dbConnect(MySQL(), user = 'root', password = '', dbname = 'manu',host = 'localhost') 

 sql<-sprintf("select * from net where ips1=%s;",id) 
 up = dbGetQuery(mysqlconnection, sql)

I am trying to retrieve records from the table net using R. I want to retrieve the records with a specific id which is being passed as a command line argument.However i am getting an error near " ips1=%s ",saying that the SQL syntax which i used is incorrect. Any help?

Uwe · Accepted Answer · 2016-06-22 06:26:33Z

1

Please, try to enclose the string value to compare in single quotes ':

sql <- sprintf("select * from net where ips1='%s';",id)

answered Jun 22, 2016 at 6:26

Uwe

42.8k13 gold badges97 silver badges143 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL query in R to compare with certain value [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related