So, in this section you have seen how to create basic transactions using BEGIN, COMMIT, and ROLLBACK. Remember that not all databases support transactions, and some support transactions different than others. So consult your database server documentation before you jump into a big database project.

start sidebar
Special Note for MySQL Users

Since MySQL does not support transactions on all table types, some tables in a database are transaction-safe, but others (that need to be accessed faster) are not. If a transaction includes data from nontransaction-safe tables, an attempt to ROLLBACK will cause an error. Always be aware of the underlying database structure when writing code to use transactions in MySQL. Code intended to be portable to a variety of systems, possibly where older versions of MySQL are in use, should not use transactions.

end sidebar

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

Similar book on Amazon © 2008-2017.
If you may any questions please contact us: