[PHP] AUTO_INCREMENT problems

[Phil Schwarzmann]

I have an exsisting table without any rows.  I tried to add a new column
to it and make it an "auto increment" column.  But when I do I get
this...

ALTER TABLE patients CHANGE  id id MEDIUMINT (9) DEFAULT   not null
AUTO_INCREMENT

MySQL said: You have an error in your SQL syntax near '' at line 1

..what did i do wrong?

Thanks!