In MariaDB, identifiers are enclosed in backticks, e.g. `x`.
`x`
# S4 method for MariaDBConnection,character dbQuoteIdentifier(conn, x, ...)# S4 method for MariaDBConnection,SQL dbQuoteIdentifier(conn, x, ...)# S4 method for MariaDBConnection,Id dbQuoteIdentifier(conn, x, ...)# S4 method for MariaDBConnection,SQL dbUnquoteIdentifier(conn, x, ...)# S4 method for MariaDBConnection,character dbQuoteString(conn, x, ...)# S4 method for MariaDBConnection,SQL dbQuoteString(conn, x, ...)
# S4 method for MariaDBConnection,SQL dbQuoteIdentifier(conn, x, ...)
# S4 method for MariaDBConnection,Id dbQuoteIdentifier(conn, x, ...)
# S4 method for MariaDBConnection,SQL dbUnquoteIdentifier(conn, x, ...)
# S4 method for MariaDBConnection,character dbQuoteString(conn, x, ...)
# S4 method for MariaDBConnection,SQL dbQuoteString(conn, x, ...)
# NOT RUN { if (mariadbHasDefault()) { con <- dbConnect(RMariaDB::MariaDB()) dbQuoteIdentifier(con, c("a b", "a`b")) dbQuoteString(con, c("a b", "a'b")) dbDisconnect(con) } # }
Run the code above in your browser using DataLab