I cannot figure out what the heck is wrong with either of these two create table queries. Any ideas? It's my first venture into the V4.x series of Mysql, on linux from binary.
mysql> CREATE TABLE account (
-> number int(11) DEFAULT 0 NOT NULL auto_increment,
-> state tinyint(4) DEFAULT '0' NOT NULL,
-> it char(20));
ERROR 1067: Invalid default value for 'number'
mysql> CREATE TABLE account (
-> number int(11) DEFAULT '0' NOT NULL auto_increment,
-> state tinyint(4) DEFAULT '0' NOT NULL,
-> it char(20));
ERROR 1067: Invalid default value for 'number'
mysql> CREATE TABLE account (
-> number int(11) DEFAULT 0 NOT NULL auto_increment,
-> state tinyint(4) DEFAULT '0' NOT NULL,
-> it char(20));
ERROR 1067: Invalid default value for 'number'
mysql> CREATE TABLE account (
-> number int(11) DEFAULT '0' NOT NULL auto_increment,
-> state tinyint(4) DEFAULT '0' NOT NULL,
-> it char(20));
ERROR 1067: Invalid default value for 'number'