Daily Archives: May 14, 2009

Use UNSIGNED INT (or BIGINT if needed) for primary key, since you don’t need negative primary keys. Don’t use ON DELETE CASCADE, since you might delete rows you wanted to keep.  Explicitly delete rows in your code. Don’t use ON … Continue reading →