MACROMEDIA ColdFusion Server 5, Руководство пользователя

Страница: 131 / 328

Using SQL Builder for Database Queries 113
The SQL Builder user interface
The following graphic shows the SQL Builder user interface:
The SQL Builder is divided into these sections:
•
Toolbar Contains buttons for SQL keywords and commands
•
Table pane Provides a view of the tables in a query and lets you create joins
between tables
•
Properties pane Lets you set the properties of a query, such as the columns to
select and the columns to update
•
SQL pane Displays the SQL statement as it is being constructed.
The SQL pane does not support reverse editing, so any changes that you make in
this pane are not made in the Properties pane or the Table pane.
Writing SQL statements
When SQL Builder opens, it displays a SELECT statement by default, since this is the
most common type of query. If you have not yet selected a table for your query, you
are prompted to select one.
SQL Builder supports these types of SQL statements:
•
Select Retrieves rows or columns of data from a table
•
Insert Adds data to a table
•
Update Changes data in a table
•
Delete Deletes data from a table