Unless outlook is just formatting your message strangley it looks like the actual name of the ID field is `ID ` with two space char's included. As such you probably want to reccreate the table using `ID` in the create statement so that it will get created as you expect without these extra chars.
John A. McCaskey -----Original Message----- From: kaustubh shinde [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 1:11 PM To: Michael Kruckenberg Cc: [EMAIL PROTECTED] Subject: Re: Error 1054 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]