create new sqlite database code example

Example 1: how to create a database in sqlite

$sqlite3 DatabaseName.db

Example 2: sqlite populate database from file command shell

sqlite3 test.db
sqlite3> .read create-tables.sql