mariadb-quoting: Quote MariaDB strings and identifiers.

Description Usage Examples

Description

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

Usage

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
## 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, ...)

Examples

1
2
3
4
5
6
if (mariadbHasDefault()) {
  con <- dbConnect(RMariaDB::MariaDB())
  dbQuoteIdentifier(con, c("a b", "a`b"))
  dbQuoteString(con, c("a b", "a'b"))
  dbDisconnect(con)
}

RMariaDB documentation built on May 7, 2018, 1:03 a.m.