List:MySQL on Win32« Previous MessageNext Message »
From:Michael Widenius Date:September 25 1999 3:51pm
Subject:RE: create table in 3.21.31
View as plain text  
>>>>> "Dennis" == =?iso-8859-1?Q?Dennis Thrys=F8e?= <iso-8859-1>
> writes:

Dennis> Hi,
Dennis> What would be wrong with this statement in version 3.21.31?

Dennis> CREATE TABLE Test3
Dennis> (
Dennis> 	ID		INT	PRIMARY KEY NOT NULL auto_increment,
Dennis> 	FactText	TEXT
Dennis> )

Dennis> mySQL reports a parse error in the decleration of ID (always near
Dennis> auto_increment).


Hi!

Move PRIMARY KEY last !

The syntax for a column definition is.

  col_name type [NOT NULL | NULL] [DEFAULT default_value] [AUTO_INCREMENT]
            [PRIMARY KEY] [reference_definition]

Regards,
Monty
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