Linux Shell Scripting Cookbook - Third Edition

Inserting a row into an SQL database

The insert command will insert a row of data into the database.

    INSERT INTO table (columns) VALUES (val1, val2,...); 

The following command inserts the book you're currently reading:

    INSERT INTO book (title, author) VALUES ('Linux Shell Scripting   
    Cookbook', 'Clif Flynt');