Deprecated: The each() function is deprecated. This message will be suppressed on further calls in /home/zhenxiangba/zhenxiangba.com/public_html/phproxy-improved-master/index.php on line 456
bobby-tables.com: A guide to preventing SQL injection in {currlang}
[go: Go Back, main page]

 

R =

R has separate interfaces for different databases, with different capabilities for each. RSQLite supports parameterized.

con <- dbConnect(SQLite(), ":memory:")
# Use dbSendPreparedQuery/dbGetPreparedQuery for "prepared" queries
dbGetPreparedQuery(con, "SELECT * FROM arrests WHERE Murder < ?",
    data.frame(x = 3))
dbDisconnect(con)

But other interfaces, such as RMySQL do not allow parameterizations.

The database drivers for R are in process of being brought together under DBI, so it is possible this will change in the future.