Contents > Getting Started Building ColdFusion MX Applications > Database Fundamentals > About SQL > Using SQL to interact with a database PreviousNext

Using SQL to interact with a database

Unlike other computer languages, SQL is made up of a small number of language elements that let you interact efficiently with a database. Some of the more frequently used elements include these SQL commands:

Command

Description

SELECT

Use to retrieve (query) information in a database.

INSERT

Use to add records to a database.

UPDATE

Use to update information in a database.

DELETE

Use to delete information in a database.

In Part II of this book, you will be introduced to the syntax of these commands when you use them to build a ColdFusion application that interacts with a database. For additional information about SQL, consult any SQL primer.


Contents > Getting Started Building ColdFusion MX Applications > Database Fundamentals > About SQL > Using SQL to interact with a database PreviousNext

ColdFusion 9 | ColdFusion 8 | ColdFusion MX 7 | ColdFusion MX 6.1 | ColdFusion MX | Forums | Developer Center | Bug Reporting

Version 6.1

Comments are no longer accepted for ColdFusion MX 6.1. ColdFusion 8 is the current version.

 

Send me an e-mail when comments are added to this page | Comment Report

Current page: http://livedocs.adobe.com/coldfusion/6.1/htmldocs/db_basi6.htm