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.

3.5.1. SELECT

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 ...

Get Linux Appliance Design now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.