Thread: default '0'
View Single Post

   
  #3 (permalink)  
Old 02-28-2008, 07:34 AM
JasiekS
 
Posts: n/a
Default Re: default '0'


Użytkownik "bruno - bdf" <bruno.bdf@free.fr> napisał w wiadomości
news:443767de$0$20270$626a54ce@news.free.fr...

> I try to create a table with this statment
> CREATE TABLE referants (
> id int(10) DEFAULT '0' NOT NULL auto_increment,


You cannot use 'DEFAULT something' and 'auto_increment' in the same
statement. You should remove DEFAULT and leave auto_increment only - as
you wish unique id. You can also remove 'NOT NULL'.

--
JasiekS
Warsaw, Poland

Reply With Quote