On Thu, Sep 06, 2001 at 01:02:59PM +0200, Kristoffer Larsson wrote:
> I just tried to create a table called "order", with this command:
>
> create table order (
> orderID INT not null,
> constraint P_Key_6 primary key (orderID)
> );
>
> It didn't work, I got an error message. When I qualified the name
> with the database, it worked though:
>
> create table trDB.order (
> orderID INT not null,
> constraint P_Key_6 primary key (orderID)
> );
>
>
> Isn't this rather strange? GUIs won't understand to qualify it like
Such GUIs are broken.
> that and thus fail on any operations performed on that table. My
> guess is that mySQL thinks I'm trying to write ORDER BY. Well,
> that's kind of stupid of it, don't you think? :)
Do I think it's stupid of MySQL? No.
`order' is a reserverd word in MySQL.
Wesley.
---------------------------------------------------------------------
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
