subject:"\[PHP\] AUTO_INCREMENT problems"

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 I have an exsisting table

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