Mind the SQL_MODE when running ALTER TABLE

(Augusto Bott) The other day, a client mentioned they were getting strange results when running ALTER TABLE. The episode involved modifying an existing primary key to add an auto_increment primary key: it was shifting values. Say what?!

Read More - Register for Free Membership