Transaction Caveats

Some commands are intrinsically impossible to undo; issuing them causes an immediate and permanent change to the database. In MySQL, these commands are:

  • ALTER TABLE

  • BEGIN

  • CREATE INDEX

  • DROP DATABASE

  • DROP TABLE

  • LOCK TABLES

  • RENAME TABLE

  • TRUNCATE

Issuing these commands in transactional mode immediately terminates the current transaction as if a COMMIT command has been issued. (Note, in particular, the presence in the list of BEGIN; it is not possible to "nest" transactions in MySQL.) Users of other databases will find similar restrictions and should consult their database documentation for details.



Perl Database Programming
Perl Database Programming
ISBN: 0764549561
EAN: 2147483647
Year: 2001
Pages: 175

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net