mer.custid
> >GROUP BY order.custid;
>
> Here order is used as a table name, not column 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&qu
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
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 res
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
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 worke
