Become an expert in R — Interactive courses, Cheat Sheets, certificates and more!
Get Started for Free

mariadb-quoting

Quote MariaDB strings and identifiers.


Description

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

Usage

## S4 method for signature 'MariaDBConnection,character'
dbQuoteIdentifier(conn, x, ...)

## S4 method for signature 'MariaDBConnection,SQL'
dbQuoteIdentifier(conn, x, ...)

## S4 method for signature 'MariaDBConnection,Id'
dbQuoteIdentifier(conn, x, ...)

## S4 method for signature 'MariaDBConnection,SQL'
dbUnquoteIdentifier(conn, x, ...)

## S4 method for signature 'MariaDBConnection,character'
dbQuoteString(conn, x, ...)

## S4 method for signature 'MariaDBConnection,SQL'
dbQuoteString(conn, x, ...)

## S4 method for signature 'MariaDBConnection'
dbQuoteLiteral(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)
}

RMariaDB

Database Interface and 'MariaDB' Driver

v1.1.1
GPL-3
Authors
Kirill Müller [aut, cre] (<https://orcid.org/0000-0002-1416-3412>), Jeroen Ooms [aut] (<https://orcid.org/0000-0002-4035-0289>), David James [aut], Saikat DebRoy [aut], Hadley Wickham [aut], Jeffrey Horner [aut], R Consortium [fnd], RStudio [cph]
Initial release

We don't support your browser anymore

Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.