Hi all,
whenever I try to upload tables into a database using an external file I
get the following error:
ERROR: Invalid deafult value for 'id'
where id is a field in one of the tables.
The command I use to to upload the database id
# mysql -u root dbname < filename
where the filename contains:
CREATE TABLE employee( id int(11) DEFAULT '0' NOT NULL auto_increment,
name varchar(30) NOT NULL, PRIMARY KEY (id) );
Pl. help immediately.
Thanx.
Seshan.
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
