(mysql.info) retrieving-data

Info Catalog

(mysql.info) loading-tables

(mysql.info) database-use

 
 3.3.4 Retrieving Information from a Table
 -----------------------------------------
 

Menu

 
* selecting-all                Selecting All Data
* selecting-rows               Selecting Particular Rows
* selecting-columns            Selecting Particular Columns
* sorting-rows                 Sorting Rows
* date-calculations            Date Calculations
* working-with-null            Working with `NULL' Values
* pattern-matching             Pattern Matching
* counting-rows                Counting Rows
* multiple-tables              Using More Than one Table
 
 The `SELECT' statement is used to pull information from a table. The
 general form of the statement is:
 
      SELECT WHAT_TO_SELECT
      FROM WHICH_TABLE
      WHERE CONDITIONS_TO_SATISFY;
 
 WHAT_TO_SELECT indicates what you want to see. This can be a list of
 columns, or `*' to indicate `all columns.' WHICH_TABLE indicates the
 table from which you want to retrieve data. The `WHERE' clause is
 optional. If it is present, CONDITIONS_TO_SATISFY specifies one or more
 conditions that rows must satisfy to qualify for retrieval.
 

Info Catalog

(mysql.info) loading-tables

(mysql.info) database-use