MACROMEDIA COLDFUSION MX 61-DEVELOPING COLDFUSION MX, Develop Manual

Page: 416 / 860

416 Chapter 19: Introduction to Databases and SQL
You interpret this statement as "Select the columns FirstName and LastName from the table
employees where the DeptID is 3".
In addition to with reading data from a table, you can write data to a table using the SQL
INSERT statement. The following statement adds a new row to the employees table:
INSERT INTO employees(EmpID, LastName, Firstname)
VALUES(51, 'Doe', 'John')
Basic SQL syntax elements
The following sections briefly describes the main SQL command elements.
Statements
A SQL statement always begins with a SQL verb. The following keywords identify commonly
used SQL verbs:
Statement clauses
Use the following keywords to refine SQL statements:
Operators
The following basic operators specify conditions and perform logical and numeric functions:
Keyword Description
SELECT Retrieves the specified records.
INSERT Adds a new row.
UPDATE Changes values in the specified rows.
DELETE Removes the specified rows.
Keyword Description
FROM Names the data tables 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.
Operator Description
AND Both conditions must be met
OR At least one condition must be met
NOT Exclude the condition following
LIKE Matches with a pattern
IN Matches with a list of values
BETWEEN Matches with a range of values
= Equal to