aing

I have mysql syntax as seen below, and there is problem on it. I'm using mysql 4.1.21-standard version
????: NamePros.com http://www.namepros.com/programming/332211-need-help-1067-invalid-default-value.html


CREATE TABLE alumni (
ID int(11) DEFAULT '0' NOT NULL auto_increment,
First_Name varchar(56) NOT NULL,
Last_Name varchar(128) NOT NULL,
bla...bla...bla...
bla...bla...bla...
bla...bla...bla...
PRIMARY KEY (ID),
KEY ID (ID)
);

and it appears error #1067 - Invalid default value for 'ID'

what should i do? should i change the default value with DEFAULT ''?
but i think the '' value just for text not for integer

anyone could solve this error?
many thanks

aing

__________________

sdsinc

There is no need to specify a default for a ID column. Since it's autonumber the system will always generate a value automatically.

__________________
NameNewsletter.com - free lists of available domain names
ZoneFiles.net (beta) - ccTLD and gTLD droplists

aing

so, do i have to delete the DEFAULT '0'?
will it affect to result?
i did it and it goes OK, but the script get error maybe it because of my setting
Thanks anyway

__________________

sdsinc

If you remove DEFAULT '0' you should be OK.
If you still have errors please post the error message.

__________________
NameNewsletter.com - free lists of available domain names
ZoneFiles.net (beta) - ccTLD and gTLD droplists