- DDL
create table table_name (cols, ...)
drop table table_name- DML
select cols, ... from table_name [where ...]
insert into table_name (cols, ...) values (v, ...)
delete from table_name [where ...]>select name, age from demo
┏━━━┳━━━━━━┳━━━━━┓
┃ ┃ name ┃ age ┃
┡━━━╇━━━━━━╇━━━━━┩
│ 1 │ foo │ 12 │
│ 2 │ bar │ 16 │
│ 3 │ baz │ 6 │
└───┴──────┴─────┘| Command | Description |
|---|---|
| .showdb | Prints the DB |
| .help | Prints this help menu and exits |
| .exit | Exits the REPL |
| .debug [on|off] | Turns debug mode on or off |
| .db [filename] | Changes db file location |