MySQL Performance Example Was: Seriously, WTF?

[Martin A. Brooks]

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 |  http://www.antibodymx.net/ | Anti-spam & anti-virus
   Consultant    |  martin at antibodymx.net      | filtering. Inoculate
 antibodymx.net  |  m: +447792493388           | your mail system.