← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to docs/queries.rst

  • Committer: Stewart Smith
  • Date: 2010-03-18 12:01:34 UTC
  • mto: (1666.2.3 build)
  • mto: This revision was merged to the branch mainline in revision 1596.
  • Revision ID: stewart@flamingspork.com-20100318120134-45fdnsw8g3j6c7oy
move RAND() into a plugin

Show diffs side-by-side

added added

removed removed

Lines of Context:
docs/queries.rst
1
 
Executing Queries 
2
 
=================
3
 
 
4
 
Queries retrieve data from a database based on specific criteria. They
5
 
are performed with the declarative SELECT statement, which has no
6
 
persistent effects on the database. SELECT simply retrieves data from
7
 
one or more tables, or expressions.
8
 
 
9
 
A query includes a list of columns to be included in a result set; an example of this would be:  ::
10
 
 
11
 
        SELECT * FROM table_1;
12
 
 
13
 
SELECT * FROM is an example of using SELECT with a clause. Other keywords and clauses include:
14
 
 
15
 
* The FROM clause
16
 
* The WHERE clause
17
 
* The GROUP BY clause
18
 
* The HAVING clause
19
 
* The ORDER BY clause
 
 
b'\\ No newline at end of file'