← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to docs/queries.rst

  • Committer: David Shrewsbury
  • Date: 2010-10-11 17:20:14 UTC
  • mfrom: (1838 trunk-drizzle)
  • mto: (1838.1.2 build)
  • mto: This revision was merged to the branch mainline in revision 1839.
  • Revision ID: shrewsbury.dave@gmail.com-20101011172014-sij1m2doi2fl2duo
Merge from trunk and resolve conflicts

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'