Linux Shell Scripting Cookbook - Third Edition

Creating a table

Tables are defined with the CREATE TABLE command:

    CREATE TABLE tablename (field1 type1, field2 type2,...); 

The next line creates a table of books and authors:

    CREATE TABLE book (title STRING, author STRING);