backticks didnt work :(
--- Victor Pendleton <[EMAIL PROTECTED]> wrote:
> 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]
__________________________________
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]
