Possibly because, if there is no typo, your table's name field is: dr. smith1 (note the period after "dr")
But your query is looking for dr smith1
Does that fix it for you?
Wes
On Jul 5, 2004, at 4:18 PM, bruce wrote:
hi...
a basic select question/issue that should work....
mysql> select * from instructorTBL; +------------+--------------+--------+-----------------+-------+----+ | name | universityID | deptID | email | phone | ID | +------------+--------------+--------+-----------------+-------+----+ | dr. smith1 | 1 | 2 | [EMAIL PROTECTED] | | 1 | +------------+--------------+--------+-----------------+-------+----+ 1 row in set (0.00 sec)
why don't any of the following work...??? as you can see, there is information in the tbl... mysql indicates it should work... what simple mistake am i missing..??
this is getting embarrassing...
mysql> select instructorTBL.ID -> from instructorTBL -> where instructorTBL.name = "dr smith1"; Empty set (0.00 sec)
mysql> select ID -> from instructorTBL -> where instructorTBL.name = "dr smith1"; Empty set (0.01 sec)
mysql> select * -> from instructorTBL -> where instructorTBL.name = "dr smith1"; Empty set (0.00 sec)
thanks...
-bruce
--
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]
