subject:"\[PHP\] AUTO_INCREMENT problems"

Re: [PHP] AUTO_INCREMENT problems

2002-01-17 Thread J.F.Kishor

hello, I think the following may solve your problem. alter table patients change id id mediumint (9) default 0 not null primary key auto_increment; On Thu, 17 Jan 2002, Phil Schwarzmann wrote: > I have an exsisting table without any rows. I tried to add a new column > to it and make it an "a

Re: [PHP] AUTO_INCREMENT problems

2002-01-17 Thread Dennis Moore

Try... ALTER TABLE patients CHANGE id id MEDIUMINT not null primary key AUTO_INCREMENT /dkm - Original Message - From: "Phil Schwarzmann" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 17, 2002 12:35 PM Subject: [PHP] AUTO_INCREMENT problems

[PHP] AUTO_INCREMENT problems

2002-01-17 Thread 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