dbEscapeStrings {RMySQL}R Documentation

Escape SQL-special characters in strings

Description

is expected to be sorted by the grouping field.

Usage

dbEscapeStrings(con, strings, ...)

Arguments

con a connection object (see dbConnect).
strings a character vector.
... any additional arguments to be passed to the dispatched method.

Details

dbEscapeStrings

Currently, only the MySQL driver implements this method.

Value

A character vector with SQL special characters properly escaped.

See Also

MySQL dbSendQuery fetch

Examples

## Not run: 
tmp <- sprintf("select * from emp where lname = %s", "O'Reilly")
sql <- dbEscapeString(con, tmp)
dbGetQuery(con, sql)
## End(Not run)

[Package RMySQL version 0.6-0 Index]