MACROMEDIA COLDFUSION 4.5-DEVELOPING WEB, Develop Manual

Page: 48 / 380

22 Developing Web Applications with ColdFusion
When the database processes the SQL, it creates a data set that is returned to
ColdFusion Server. ColdFusion places the data set in memory and assigns it the name
that you defined for the query in the begin CFQUERY tag.
You may reference that data set by name using the CFOUTPUT tag further down on the
page.
Basic SQL Syntax elements
The following sections present brief descriptions of the main SQL command elements.
Statements
These keywords identify commonly-used SQL commands:
Statement clauses
These keywords are used to refine SQL statements:
Basic SQL Statements
Keyword Description
SELECT Retrieves the specified records
INSERT Adds a new row
UPDATE Changes values in the specified rows
DELETE Removes the specified rows
Basic SQL Clauses
Keyword Description
FROM Names the data source for the operation
WHERE Sets one or more conditions for the operation
ORDER BY Sorts the result set in the specified order.
GROUP BY Groups the result set by the specified select list items.