MySQL Performance Example Was: Seriously, WTF?

Martin A. Brooks martin at
Fri May 9 23:44:27 BST 2008

Michael Lush wrote:
>> The latter gives you an option to make what you've tried to do go 
>> away with no impact to other users, the former doesn't.
> If the operation succeeds,  its going to have an impact on other users.
> If the operation fails, can it have a greater impact than that of
> success? 

The option is you can type "rollback;" after the insert and it never 
happened.  With just the insert on its own you can't.

Martin A. Brooks | | Anti-spam & anti-virus
   Consultant    |  martin at      | filtering. Inoculate  |  m: +447792493388           | your mail system. 

More information about the mailing list