ALTER TABLE patients CHANGE  id id MEDIUMINT not null primary key

----- Original Message -----
From: "Phil Schwarzmann" <[EMAIL PROTECTED]>
Sent: Thursday, January 17, 2002 12:35 PM
Subject: [PHP] AUTO_INCREMENT problems

> 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
> MySQL said: You have an error in your SQL syntax near '' at line 1
> ..what did i do wrong?
> Thanks!

PHP General Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to