Try using backticks `ID`
-----Original Message-----
From: kaustubh shinde
To: [EMAIL PROTECTED]
Sent: 5/26/04 1:05 PM
Subject: Error 1054
Hi,
I have a table Spot in the database as follows
desc Spot
-> ;
+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default |
Extra |
+---------------+-------------+------+-----+---------+-------+
| Name | varchar(32) | YES | | NULL |
|
| ID | int(11) | | PRI | 0 |
|
| Row | varchar(32) | YES | | NULL |
|
| Column | varchar(32) | YES | | NULL |
|
| Probe_ID | int(11) | | | 0 |
|
| Array_Type_ID | int(11) | | | 0 |
|
+---------------+-------------+------+-----+---------+-------+
When I try to access the field ID shown above though,
it gives me error:
mysql> select ID from Spot;
ERROR 1054: Unknown column 'ID' in 'field list'
This is kind of weird. I will really appreciate any
ideas
Thank you,
Kaustubh
__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
