SQLite Notes

Open Specific Database with SQLite:

Note: If you don’t designate a database a temporary one will be created which will ceae to exist when you exit.

sqlite3 database_name.db

Exit Console:


Open database from SQLite Console:

.open database_name.db

Create Table:

create table your_table(
  name TEXT,
  email TEXT

Select Statements:

select * from your_table;

select column1, column2 from your_table;

select * from your_table where name='bob';

select * from your_table where name like '%bob%';

Show Tables:


Show Schema:

Turns on Headers for all Select Statements
.headers on
Shows the command that created a specific table
.schema your_table

Be the first to comment

Leave a Reply