Category Archives: MySQL

MySQL Transactions will automatically rollback if not committed

Posted on September 3, 2009 by Richard

Just a quick note on this one, because although it seems obvious, I couldn’t find this explicitly mentioned anywhere in the MySQL manual entry for transaction syntax. However if you issue an SQL ‘START TRANSACTION’ statement, anything you do after … Continue reading →

Posted in MySQL | Leave a comment

Watch out for calculations with MySQL unsigned integers

Posted on April 29, 2009 by Richard

Unsigned integers are a useful column type in MySQL if you want to make your tables as small as possible. Making tables small is a good idea because at the end of the day, database access is limited by hard … Continue reading →

Posted in MySQL | 1 Comment