Re: SQL PRIMARY KEY question

2001-02-17 Thread Fred van Engen
On Sat, Feb 17, 2001 at 12:07:53PM +0100, Cedric Lefebvre wrote: > I have written the following SQL request, but I get > an error, why ? > > create table MovementOrder ( > teamCode INT(4) NOT NULL, > quarter INT(4) NOT NULL, > position INT(4) NOT NULL, > priority INT(4) NOT NULL, > orde

Re: SQL PRIMARY KEY question

2001-02-17 Thread Artem Koutchine
- From: "Cedric Lefebvre" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, February 17, 2001 2:07 PM Subject: SQL PRIMARY KEY question > I have written the following SQL request, but I get > an error, why ? > > create table MovementOrder ( > t

SQL PRIMARY KEY question

2001-02-17 Thread Cedric Lefebvre
I have written the following SQL request, but I get an error, why ? create table MovementOrder ( teamCode INT(4) NOT NULL, quarter INT(4) NOT NULL, position INT(4) NOT NULL, priority INT(4) NOT NULL, order VARCHAR(10), parameter VARCHAR(5), PRIMARY KEY(teamCode,quarter,position,prio