Linux Shell Scripting Cookbook - Third Edition

How to do it...

The sqlite3 command is an interactive database engine that connects to a SQLite database and supports the process of creating tables, inserting data, querying tables, and so on.

The syntax of the sqlite3 command is this:

    sqlite3 databaseName

If the databaseName file exists, sqlite3 will open it. If the file does not exist, sqlite3 will create an empty database. In this recipe, we will create a table, insert one row, and retrieve that entry:

    # Create a books database
    $ sqlite3 books.db
    sqlite> CREATE TABLE books (title string, author string);
    sqlite> INSERT INTO books (title, author) VALUES ('Linux Shell      
    Scripting Cookbook', 'Clif Flynt');
    sqlite> SELECT * FROM books WHERE author LIKE '%Flynt%';
 Linux Shell Scripting ...