Re: Using 'Key' as Column-Name

2001-02-23 Thread MikeBlezien
On Fri, 23 Feb 2001 18:56:08 +0100, "CGint" <[EMAIL PROTECTED]> wrote: >>I'm about to migrate from an MS-access to MySQL. >> >>I named my primary-key-columns 'Key'. >>Now, if i try to query this column I get an error: >> >>mysql> SELECT key, description FROM project; >>ERROR 1064: You have an e

Using 'Key' as Column-Name

2001-02-23 Thread CGint
I'm about to migrate from an MS-access to MySQL. I named my primary-key-columns 'Key'. Now, if i try to query this column I get an error: mysql> SELECT key, description FROM project; ERROR 1064: You have an error in your SQL syntax near 'key, description FROM project' at line 1 If I try SELEC