jvervloet's Journal: Altering tables in mysql

MySQL is a very powerful database, if you remember its syntax. One of the things I always forget, is how to alter a table.

Adding an auto-incrementing primary key.

[jvervloet]

In this particular case, I had to add an auto-incrementing primary key, which was not described in the text. Luckily, the MySQL manual [mysql.com] led me to the solution:

ALTER TABLE gastenboek ADD COLUMN id mediumint(9) auto_increment, ADD PRIMARY KEY(id);

Before doing this, I had to drop the previous primary key:

ALTER TABLE gastenboek DROP PRIMARY KEY;