(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
automatically generated byinfo2html