RMariaDB (version 1.3.1)

mariadb-quoting: Quote MariaDB strings and identifiers.

Description

In MariaDB, identifiers are enclosed in backticks, e.g. `x`.

Usage

# S4 method for MariaDBConnection,Id
dbQuoteIdentifier(conn, x, ...)
# S4 method for MariaDBConnection,SQL
dbQuoteIdentifier(conn, x, ...)
# S4 method for MariaDBConnection,character
dbQuoteIdentifier(conn, x, ...)
# S4 method for MariaDBConnection
dbQuoteLiteral(conn, x, ...)
# S4 method for MariaDBConnection,SQL
dbQuoteString(conn, x, ...)
# S4 method for MariaDBConnection,character
dbQuoteString(conn, x, ...)
# S4 method for MariaDBConnection,SQL
dbUnquoteIdentifier(conn, x, ...)

Examples

if (mariadbHasDefault()) {
  con <- dbConnect(RMariaDB::MariaDB())
  dbQuoteIdentifier(con, c("a b", "a`b"))
  dbQuoteString(con, c("a b", "a'b"))
  dbDisconnect(con)
}