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!
Now my questions:
- Can't I use 'key' as column-name ?
My System:
- MySQL 3.23.33 on Windows NT4 SP4
- local database via TCP/IP
- query-tool: mysql
- other-test-connection: JAVA 1.1.8 via JDBC-Driver mm.mysql-2.0.4 from Mark Matthews
Thanks a lot
CGint
--------------------------------------------
Break the rules when it seems wise.
---------------------------------------------------------------------
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
