You can't - auto_increment cannot have a default value, AFAIAA. Terry
----- Original Message ----- > mysql> create table list_admin ( > -> admin_id int(11) default '0' not null auto_increment > -> ); > ERROR 1067 (42000): Invalid default value for 'admin_id' > > How can I set default value to 0? > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
