transactions | R Documentation |
Commits or roll backs the current transaction in an MariaDB connection.
Note that in MariaDB DDL statements (e.g. CREATE TABLE
) cannot
be rolled back.
## S4 method for signature 'MariaDBConnection' dbBegin(conn, ...) ## S4 method for signature 'MariaDBConnection' dbCommit(conn, ...) ## S4 method for signature 'MariaDBConnection' dbRollback(conn, ...)
conn |
a MariaDBConnection object, as produced by
|
... |
Unused. |
if (mariadbHasDefault()) { con <- dbConnect(RMariaDB::MariaDB(), dbname = "test") df <- data.frame(id = 1:5) dbWriteTable(con, "df", df, temporary = TRUE) dbBegin(con) dbExecute(con, "UPDATE df SET id = id * 10") dbGetQuery(con, "SELECT id FROM df") dbRollback(con) dbGetQuery(con, "SELECT id FROM df") dbDisconnect(con) }
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.