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. 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;
This is straight from the docs and such a query can't obviously work,
can it?
Kristoffer Larsson
---------------------------------------------------------------------
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