LPMJ Example 8-5

(Click on the icon to view the source for copy and pasting)

ALTER TABLE classics ADD id INT UNSIGNED
  NOT NULL AUTO_INCREMENT KEY;