> so what's the solution buddies, should I remove auto_increment or I
> should not default it. What exactly should I do now. If possible make
> changes to the Create syntax which is as follows and highlight the
> change:
>
> CREATE TABLE employee( id int(11) DEFAULT '0' NOT NULL auto_increment,
> name varchar(30) NOT NULL, PRIMARY KEY (id) );
I would say remove the default '0', since the auto_increment is going to
be needed even after. In any case, if you had read the docs, you would
have seen that AUTO_INCREMENT starts from 1. If NULL or 0 is inserted into
an AUTO_INCREMENT field, its value is taken as largest_value+1
Philip
To subscribe / unsubscribe goto the site www.ilug-bom.org ., click on the mailing list
button and fill the appropriate information
and submit. For any other queries contact the ML maintener
