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 error in your SQL syntax near 'key, description FROM
>project' at
>> line 1
>>
>>If I try SELECT * FROM project; everything is ok.
>>
>>Then I tryed to rename 'key' to 'key1'.
>>Everything works fine without an error.
>>I have over 40 tables and I don't want to change all column-names AND the
>application-querys!
This is one of those "reserved" words not allowed in MySQL. For a complete
listing reserverd words, go to:
http://www.mysql.com/doc/R/e/Reserved_words.html
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225) 686-2002
---------------------------------------------------------------------
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