Hi,
Following is the output of show create table Spot
command
| Table | Create Table
|
+-------+-----------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
------------------------------------------------------------------+
| Spot | CREATE TABLE `Spot` (
`Name` varchar(32) default NULL,
`ID ` int(11) NOT NULL default '0',
`Row` varchar(32) default NULL,
`Column` varchar(32) default NULL,
`Probe_ID` int(11) NOT NULL default '0',
`Array_Type_ID` int(11) NOT NULL default '0',
PRIMARY KEY (`ID `)
) TYPE=MyISAM |
As you can see ID was actually stored as `ID `.
My mistake. Thanks a lot for all the replies. learnt
something new today! :)
Thanks again
Kaustubh
--- Michael Kruckenberg
<[EMAIL PROTECTED]> wrote:
> 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]
>
>
__________________________________
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]
