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,
> order VARCHAR(10),
order is a reserved word which you can't use for any of your
own names (i.e. field names, table names, index names or
variable names).
> parameter VARCHAR(5),
> PRIMARY KEY(teamCode,quarter,position,priority)
> );
>
Your subject line seems to indicate a problem with PRIMARY KEY,
but without more information it's hard to tell. Please be more
elaborate on your next question. Usually you would mention the
exact error message, the version of MySQL you're using, the OS
you're running on, client software used (like PHP, Perl), etc.
Fred.
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
