List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 27 1999 11:49am
Subject:Re: Problem with CREATE TABLE
View as plain text  
At 8:57 AM +0000 5/27/1999, Sandrine C. wrote:
>YHello, me again !
>
>I send a message this mornig telling i had problem inserting the 11th item
>in a table.
>the answer was because my autoincrement field was a varchar. so i changed it
>with a BIGINT.. but now I have error, and dont see what s awrong with my
>syntax. i have the myql manual in front of me, and really, i  dont see
>anythg wrong... SO IF YOU HAVE BETTER EYES TAHN I !!
>
>here is the table i want to creat and the error message
>mysql> CREATE TABLE organisme (
>    ->         OR_Code                 BIGINT(8) ZEROFILL PRIMARY KEY
>AUTO_INCREMENT NOT NULL,
>    ->         OR_Raison               VARCHAR(40) UNIQUE NOT NULL,
>    ->         OR_Libelle              VARCHAR(50),
>    ->         AD_Adresse              BIGINT(8) ZEROFILL,
>    ->         OR_Statut               ENUM('', 'Prive', 'Public'),
>    ->         OR_Implementation       ENUM('', 'Nationale', 'Regionale',
>'Locale'),
>    ->         CO_Directeur            BIGINT(8) ZEROFILL,
>    ->         CO_InterlPrinc          BIGINT(8) ZEROFILL,
>    ->         OR_Etat                 ENUM ('Actif', 'Inactif', 'En
>Attente') NOT NULL,
>    ->         OR_DateMAJ              DATE NOT NULL,
>    ->         INDEX OR_index          (OR_Code, OR_Etat, OR_Raison,
>OR_DateMAJ) );
>ERROR 1064: You have an error in your SQL syntax near 'UNIQUE NOT NULL,
>        OR_Libelle              VARCHAR(50),
>        AD_Adresse' at line 3

UNIQUE should follow NOT NULL, not precede it.

--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
Thread
Problem with CREATE TABLESandrine C.27 May
  • Re: Problem with CREATE TABLEPaul DuBois27 May