~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to docs/where.rst

Committer: Lee Bieber
Date: 2011-01-15 03:08:27 UTC
mfrom: (1994.5.38 doc)
mto: This revision was merged to the branch mainline in revision 2087.
Revision ID: kalebral@gmail.com-20110115030827-0h9s99kiknrmt9ti

Merge Stewart - some documentation clean up

files modified:
docs/aggregatefunctions.rst

docs/alter_table.rst

docs/analyze.rst

docs/check.rst

docs/columntypes.rst

docs/commit.rst

docs/create_index.rst

docs/data_dictionary.rst

docs/date_time_data_types.rst

docs/dml.rst

docs/drop_index.rst

docs/drop_schema.rst

docs/dynamic.rst

docs/groupby.rst

docs/having.rst

docs/insert.rst

docs/join.rst

docs/locks.rst

docs/logging.rst

docs/numeric_data_types.rst

docs/orderby.rst

docs/queries.rst

docs/rename.rst

docs/replace.rst

docs/replication.rst

docs/savepoints.rst

docs/scalarfunctions.rst

docs/show.rst

docs/start_transaction.rst

docs/storage_engines.rst

docs/string_data_types.rst

docs/tables.rst

docs/transactional.rst

docs/truncate.rst

docs/update.rst

docs/uuid_data_type.rst

docs/variables.rst

docs/where.rst

Show diffs side-by-side

added added

removed removed

docs/where.rst

The WHERE clause is used to extract only those records that fulfill a specified criterion.

SQL WHERE Syntax ::

Simple SQL WHERE Syntax ::

SELECT column_name(s)

FROM table_name

WHERE column_name operator value

**WHERE Clause Example**

**Simple WHERE Clause Example**

The "Persons" table:

+---------+------------+----------+----------+--------+

+---------+------------+----------+----------+--------+

b'\\ No newline at end of file'

+---------+------------+----------+----------+--------+

Older »