SQLite comes with a cli tool called sqlite3
, you can create a db by executing:
sqlite3 test.db
After executing, you will enter a command prompt in which you can enter SQL (terminated by ;
). To terminate the sqlite3
program type your system's End-Of-File character (usually Control-D).
sqlite3 test.db -init create_table.sql
sqlite3 test.db ".read create_table.sql"