mysql sql有 变量名,如何在SQL语句中使用变量名？

I'm using R to call a mySQL statement, where I define the variable outside the statement e.g.

foo = 23;

dbGetQuery(con, "select surname from names WHERE age = '.foo.' ;")

But this returns an empty set, I've googled around and tried'.&foo.' ".foo." '".&&foo."'

and many different combinations, but none of them work, I think this should be a mysql question rather than an R specific problem I'm having, but not sure. Normally variables have $values but not in R.

解决方案

This should work:

foo = 23;

sqlStatement

dbGetQuery(con, sqlStatement;)