Coding Knowledge Center
SQLite
Database (Create) |
schema.sql:
create table if not exists tasks (
task_id integer primary key autoincrement,
task_title text,
task_body text,
task_category text,
task_submitted_date text,
task_due_date text,
task_priority_id integer,
task_complete integer
);
command:
> /usr/bin/sqlite3 test.db ".read schema.sql"
Reads in a schema file with the correct sql syntax to create the tables for "test" database.