I am trying to get a select statement with "WHERE" to work and
I can't seem to do it. Below find some output. I try a select
w/WHERE by "book" but it doesn't work. Originally I tried
in PHP and didn't work, so now I just want the MYSQL to work first, I
could be overlooking something simple since I'm new to MYSQL.
Thanks, Lee G.
mysql> show columns from balloon.balloon_txt;
+-----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| access_no | varchar(20) | | PRI | | |
| recs_txt | text | YES | | NULL | |
+-----------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> SELECT * FROM balloon_txt limit 0,1;
+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| access_no | recs_txt
|
+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| BT-1034.02
| Title_____[ Balloon Capabilities and Futures]
Author____[ Thomas W. Kelly
Resp_Org__[ Air Force Cambridge Research Labs.
FundingOrg[
Date______[ Dec 1963
Report_No_[ Found in: AFCRL-TR-63-919, AFSG No. 154
Reposit_No[ Found in: AD-614 065
ContractNo[
Descript__[ Conference Paper, 25 p
Notes_____[ This symposium was held in Boston, MA on 25 to 27 September
1963. Twenty papers were presented, of which 16 were published. This
paper is found on pp 3-27.]
Subj_Terms[ Balloon technology, tethered balloons, payload orientation,
hot air balloons, balloon design, manned balloons, instrumentation]
Content___[ The papers covered present load and altitude capabilities of
many types of plastic balloons. Objectives of current research in
balloon technology are described, including extension of present
capabilities, increased reliability, and longe
r duration.]
ElecAccess[ http://library/Databases/Balloon/Data/BT1034.02.pdf
Avail_From[ WFF/BTL |
+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> SELECT * FROM balloon_txt WHERE access_no = BT-1034.2;
ERROR 1054: Unknown column 'BT' in 'where clause'
mysql> SELECT * FROM balloon_txt WHERE access_no = 'BT-1034.2';
Empty set (0.00 sec)
mysql> SELECT * FROM balloon_txt WHERE access_no = "BT-1034.2";
Empty set (0.00 sec)
mysql>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
