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 MySQL? No.
> >
> > `order' is a reserverd word in MySQL.
>
> Too bad the documentation doesn't say so.
Yes it does. Read ch. 7.39. It says that you generally cannot
use reserved names as column names.
> Actually it implies the opposite:
>
> mysql> select order.custid,customer.name,max(payments)
> from order,customer
> where order.custid = customer.custid
> GROUP BY order.custid;
Here order is used as a table name, not column name.
> This is straight from the docs and such a query can't obviously work,
> can it?
Obviously it can.
/ Carsten
--------
Carsten H. Pedersen
Keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
---------------------------------------------------------------------
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