(mysql.info.gz) Retrieving data

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

 
* 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's present, `conditions_to_satisfy' specifies
 conditions that rows must satisfy to qualify for retrieval.

Info Catalog

(mysql.info.gz) Loading tables

(mysql.info.gz) Database use

automatically generated byinfo2html

(mysql.info.gz) Retrieving data

Menu