Posted by Gilles Ganault on 06/08/07 21:29

On Fri, 08 Jun 2007 21:19:11 -0000, ZeldorBlat <zeldorblat@gmail.com>
wrote:
>Remove the quotes around 0.

It doesn't work any better:

mysql> CREATE TABLE authlib_data (id int(11) DEFAULT 0 NOT NULL
auto_increment,age int(3) DEFAULT 0 NOT NULL, PRIMARY KEY (id));

ERROR 1067 (42000): Invalid default value for 'id'

Thanks.

• Next in forum: Re: Clicked link text
• Prev in forum: Re: Why "id int(11) DEFAULT '0'"?
• Thread view: Re: Why "id int(11) DEFAULT '0'"?

[Reply to this message]