create table error
0 отговора
0 прегледа
create table error
mysql> CREATE TABLE dictionary (
-> id int(10) DEFAULT '0' NOT NULL auto_increment,
-> Type varchar(30),
-> Attribute varchar(32),
-> Value varchar(32),
-> Format varchar(20),
-> Vendor varchar(32),
-> PRIMARY KEY (id)
-> );
ERROR 1067 (42000): Invalid default value for 'id'
-> id int(10) DEFAULT '0' NOT NULL auto_increment,
-> Type varchar(30),
-> Attribute varchar(32),
-> Value varchar(32),
-> Format varchar(20),
-> Vendor varchar(32),
-> PRIMARY KEY (id)
-> );
ERROR 1067 (42000): Invalid default value for 'id'