Retrieving Data From a MySQL Database

Revision as of 17:53, 9 October 2007 by Neil (Talk | contribs) (New page: Just a database system would be useless without some way to write data to the database files, a database would be similarly useless if there were no way to extract the stored data. Amongst...)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Revision as of 17:53, 9 October 2007 by Neil (Talk | contribs) (New page: Just a database system would be useless without some way to write data to the database files, a database would be similarly useless if there were no way to extract the stored data. Amongst...)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Just a database system would be useless without some way to write data to the database files, a database would be similarly useless if there were no way to extract the stored data. Amongst the available SQL statements, one of the most frequently used is the SELECT statement. The purpose of the SELECT statement is to retrieve data from a database table based on specified criteria. In this chapter we will cover the use of the SELECT statement in detail.

Using SELECT to Retrieve Single Columns