SQL Primer

SQL Primer

This appendix describes how to use Structured Query Language (SQL) to create recordsets for your dynamic pages. SQL (pronounced sequel) is a language that lets you read and write data from a database. The language has only a few keywords and simple syntax rules, but still allows you to perform sophisticated database operations.

This appendix contains the following sections:

Syntax basics

Defining the columns of a recordset

Limiting the records in a recordset

Sorting the records in a recordset

Joining tables

Related topics

  • About databases
  • Database design basics
  • Understanding recordsets

Getting Started with Dreamweaver
Dreamweaver Basics
Working with Dreamweaver Sites
Laying Out Pages
Adding Content to Pages
Working with Page Code
Preparing to Build Dynamic Sites
Making Pages Dynamic
Developing Applications Rapidly