Maybe a long shot, but creating this table should have required using
backticks around `Column` because it's a reserved word. Made me wonder
if the ID field in the create statement was in backticks as well and
maybe has an extra character.
What does "show create table Spot" show?
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/
--
http://mike.kruckenberg.com | [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
