使用mysql建表时出现如下错误,请问如何解决
mysql> CREATE TABLE guest(-> id int(10) DEFAULT '0' NOT NULL auto_increment,
-> username varchar(21),
-> sex varchar(10),
-> email varchar(201),
-> homepage varchar(201),
-> mesg longblob,
-> posttime datetime,
-> oicq varchar(201),
-> face varchar(201),
-> icon int(20),
-> PRIMARY KEY (id)
-> );
ERROR 1067 (42000): Invalid default value for 'id'