Posted by ZeldorBlat on 06/09/07 14:31

On Jun 9, 7:30 am, Geoff Berrow <blthe...@ckdog.co.uk> wrote:
> Message-ID: <qfij63189p1ige0fq2vm5ic7rkgaf0r5o6@4ax.com> from Gilles
> Ganault contained the following:
>
> >On Fri, 08 Jun 2007 21:19:11 -0000, ZeldorBlat <zeldorb...@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'
>
> Sheesh, I'm no sql whizz but even I can work out why that is nonsense.
> auto_increment works in a similar way as DEFAULT adding a value if one
> is not set in the sql except with auto_increment (and the clue is in the
> name folks) a new unique number is added to the new row. Having both
> must surely conflict and besides, DEFAULT would be redundant
>
> --
> Geoff Berrow (put thecat out to email)
> It's only Usenet, no one dies.
> My opinions, not the committee's, mine.
> Simple RFDshttp://www.ckdog.co.uk/rfdmaker/

Doh! I should have seen that, too. Thanks Geoff.

[Back to original message]