Scott Hamm <[EMAIL PROTECTED]> wrote on 17/09/2004 13:15:30:
> 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?
I don't think you can have a default with auto-increment. Essentially,
auto_increment means "default ++counter", so you are assigning two
defaults. Which do you want, 0 or auto_increment?
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
