transactions

0th

Percentile

DBMS Transaction Management

Commits or roll backs the current transaction in an MySQL connection. Note that in MySQL DDL statements (e.g. CREATE TABLE) can not be rolled back.

Usage
# S4 method for MySQLConnection
dbCommit(conn, ...)

# S4 method for MySQLConnection dbBegin(conn, ...)

# S4 method for MySQLConnection dbRollback(conn, ...)

Arguments
conn

a MySQLConnection object, as produced by dbConnect.

...

Unused.

Aliases
  • dbBegin,MySQLConnection-method
  • dbCommit,MySQLConnection-method
  • dbRollback,MySQLConnection-method
  • transactions
Examples
# NOT RUN {
if (mysqlHasDefault()) {
con <- dbConnect(RMySQL::MySQL(), dbname = "test")
df <- data.frame(id = 1:5)

dbWriteTable(con, "df", df)
dbBegin(con)
dbGetQuery(con, "UPDATE df SET id = id * 10")
dbGetQuery(con, "SELECT id FROM df")
dbRollback(con)

dbGetQuery(con, "SELECT id FROM df")

dbRemoveTable(con, "df")
dbDisconnect(con)
}
# }
Documentation reproduced from package RMySQL, version 0.10.16, License: GPL-2

Community examples

Looks like there are no examples yet.