List:MySQL on Win32« Previous MessageNext Message »
From:Paul DuBois Date:September 25 1999 1:52pm
Subject:RE: create table in 3.21.31
View as plain text  
At 2:56 AM -0500 9/25/99, Dennis Thrysøe wrote:
>Hi,
>
>What would be wrong with this statement in version 3.21.31?
>
>CREATE TABLE Test3
>(
>	ID		INT	PRIMARY KEY NOT NULL auto_increment,
>	FactText	TEXT
>)
>
>mySQL reports a parse error in the decleration of ID (always near
>auto_increment).

Try putting PRIMARY KEY after AUTO_INCREMENT.

--
Paul DuBois, paul@stripped
Thread
MYSQL using 100% CPU constantly...John Peat24 Sep
  • MYSQL using 100% CPU constantly...Michael Widenius25 Sep
    • RE: create table in 3.21.31Dennis Thrys√łe25 Sep
      • RE: create table in 3.21.31Paul DuBois25 Sep
      • RE: create table in 3.21.31Michael Widenius25 Sep
      • Re: create table in 3.21.31Tonu Samuel26 Sep
  • Re: MYSQL using 100% CPU constantly...John Peat26 Sep
    • Re: MYSQL using 100% CPU constantly...Michael Widenius26 Sep
  • Re: MYSQL using 100% CPU constantly...John Peat26 Sep