dbCommit-methods {RMySQL} | R Documentation |
Commits or roll backs the current transaction in an MySQL connection
MySQLConnection
object, as produced by the function
dbConnect
.
See the Database Interface definition document
DBI.pdf
in the base directory of this package
or
http://stat.bell-labs.com/RS-DBI.
MySQL
,
dbConnect
,
dbSendQuery
,
dbGetQuery
,
fetch
,
dbCommit
,
dbGetInfo
,
dbReadTable
.
## Not run: drv <- dbDriver("MySQL") con <- dbConnect(drv, group = "group") rs <- dbSendQuery(con, "delete * from PURGE as p where p.wavelength<0.03") if(dbGetInfo(rs, what = "rowsAffected") > 250){ warning("dubious deletion -- rolling back transaction") dbRollback(con) } ## End(Not run)