I just tried to create a table called order, with this command:
create table order (
orderID INTnot 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
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 INTnot null,
constraint P_Key_6 primary key (orderID)
);
It didn't work, I
On Thu, 6 Sep 2001, Wesley Darlington wrote:
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
Kristoffer Larsson wrote:
On Thu, 6 Sep 2001, Wesley Darlington wrote:
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
name.
Yes, I have never talked about order as a column name, only as a
table name. In 7.40 (not 7.39) it says that most of [these keywords]
are forbidden as column and/or table names. So, the above can't
work, since a table can't be named order. Unless the above expects
you to create the table
