Linux Shell Scripting Cookbook - Third Edition

How it works...

The sqlite3 application creates an empty database named books.db and displays the sqlite> prompt to accept SQL commands.

The CREATE TABLE command creates a table with two fields: title and author.

The INSERT command inserts one book into the database. Strings in SQL are delimited with single quotes.

The SELECT command retrieves the rows that match the test. The percentage symbol (%) is the SQL wildcard, similar to a star (*) in the shell.