DEV Community

Discussion on: The Day Everyone Turned Into Michael Johnson. A Lesson In F5.

Collapse
 
lluismf profile image
Lluís Josep Martínez
  1. Never use autocommit with SQL interpreters. After the UPDATE you probably will see the number of rows updated. If it's not 1 rollback, otherwise commit.

  2. Always keep a historic table for each important entity of your system.