3.5. A Little SQL
Structured Query Language is a standard way to manipulate data in a database. RTA uses only two SQL commands: SELECT, to get data from a table, and UPDATE, to write data to a table. The RTA syntax for SELECT and UPDATE is a limited subset of the standard SQL syntax, with one minor extension.
The SELECT statement reads values out of a table. The syntax for the RTA SELECT statement is:
SELECT column_list FROM table [where_clause] [limit_clause]
The column_list is a comma-separated list of column names or a single asterisk (*) to retrieve all columns. The variable table is the name of the table you wish to examine. The where_clause specifies which rows to return, and the limit_clause tells how many rows to return. Here ...