SQL commands

The following SQL commands are used in the examples:

• select: select *: Sections Data input with SQL statements, Dense vs. sparse data format, Reading several arrays from a single table, Reading an array from several tables, select with specification of fields: Sections Data input with SQL statements, Outputting solution values, Reading an array from several tables, Selection of columns/fields, select with conditions: Section SQL selection statements.
• insert: Sections Data output with SQL statements, Outputting solution values, Outputting several arrays into a single table, Selection of columns/fields.
• create table: Sections Outputting several arrays into a single table, Selection of columns/fields.
• delete: Section Data output with SQL statements.
• drop table: Section Selection of columns/fields.
• update: Sections Outputting solution values, Selection of columns/fields.