| 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)