Hi Antony, Eventually "key" is a reserved word ?? ;-)
nice one !! Best regards Nils Valentin Tokyo/Japan 2003年 7月 7日 月曜日 18:20、Anthony Scism さんは書きました: > I am relatively new at this, but is there any way to perform the > > following: > | obs_date | date | YES | | NULL | > | > | obs_time | time | YES | | NULL | > | > | object | varchar(40) | YES | | NULL | > | > | observing_site | varchar(40) | YES | | NULL | > | > | constellation | varchar(40) | YES | | NULL | > | > | seeing | varchar(80) | YES | | NULL | > | > | magnitude | decimal(6,2) | YES | | NULL | > | > | temperature | decimal(6,2) | YES | | NULL | > | > | size | decimal(6,2) | YES | | NULL | > | > | telescope | varchar(40) | YES | | NULL | > | > | r_a | varchar(20) | YES | | NULL | > | > | d_e_c | varchar(20) | YES | | NULL | > | > | eyepiece | varchar(20) | YES | | NULL | > | > | magnification | int(11) | YES | | NULL | > | > | filter | varchar(40) | YES | | NULL | > | > | observer | varchar(40) | YES | | NULL | > | > | notes | varchar(254) | YES | | | > | > | imgurl | varchar(254) | YES | | NULL | > | > | key | int(11) | | PRI | NULL | > > auto_increment | > > | key_pls_email | varchar(100) | | | key+observer | > > +----------------+--------------+------+-----+--------------+----------- > -----+ > > select * from table where key = 1; > or > select * from table where key = '1'; > > both of these return an error of: > mysql> select * from observ_log where key=1; > ERROR 1064: You have an error in your SQL syntax near 'key=1' at line 1 > mysql> select * from observ_log where key='1'; > ERROR 1064: You have an error in your SQL syntax near 'key='1'' at line > 1 > > I can not find anything regarding using the primary key in the where > expression. > > any help would be greatly appreciated. > > A Scism > [EMAIL PROTECTED] -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
