> ERROR: Invalid deafult value for 'id'
>
> where id is a field in one of the tables.
>
> CREATE TABLE employee( id int(11) DEFAULT '0' NOT NULL auto_increment,
^^^
This is not an int. It is a string. Remove the quotes and it should
work.
> name varchar(30) NOT NULL, PRIMARY KEY (id) );
PS. I know nothing about mysql, but this is the way it works in other
DBMSes.
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
