07.10 mysql
ionas
Note
sql commit/rollback (doesnt work)
  1. BEGIN
  2.  
  3. UPDATE `accounts` SET `email` = 'mary2@test.de',`password` = '123',`id` = 97,`modified` = '2007-07-10 16:27:42' WHERE `id` IN (97)
  4.  
  5. UPDATE `admins` SET `id` = 96,`created` = '0000-00-00 00:00:00',`modified` = '0000-00-00 00:00:00',`account_id` = 97,`nickname` = 'john',`firstname` = 'mary',`lastname` = 'jane' WHERE `id` IN (96)
  6. # 1062: Duplicate entry 'john' for key 2
  7.  
  8. ROLLBACK
Parsed in 0.013 seconds, using GeSHi 1.0.7.14

Modify this Paste