Thread: table named primary

table named primary

From
Joseph Crawley
Date:
I'm not sure if this is a bug or feature but in ver7.1 on linux you
can't have a column name "primary".
thanks
Joseph Crawley

Re: table named primary

From
Stephan Szabo
Date:
On Thu, 19 Apr 2001, Joseph Crawley wrote:

> I'm not sure if this is a bug or feature but in ver7.1 on linux you
> can't have a column name "primary".

Probably because it's a reserved word as part of PRIMARY KEY.
Actually if you double quote the name everywhere you use it, it'll
probably work, but that's probably a bad idea in general.