# Sqlite3 Shell
A prettify command window to display sqlite3 interface.

|指令|說明|
|----|----|
|ls|顯示所有列表名稱與表頭|
|help|顯示所有指令|
|<任何sql語法>|執行sql指令|
|exit|離開程式(也可雙擊Enter)|

|instructions|explain|
|----|----|
|ls|show schemas of tables|
|help|show all instructions|
|<sql_command>|execute sql command|
|exit|exit program(or double click Enter)|

## installation
### 1. Goto [Github Release](https://github.com/alan890104/sqlite3-shell/releases/latest) and click db_shell.exe

### 2. Double click db_shell.exe and it will pop up a message box. Select "Other Information".(其他資訊)
### 3. Click this button(仍要執行) and you are able to use this shell!
### 4. You can named for your database or press ENTER to use default name(DB.sqlite3).
### 5. Type some sql command!!
::: danger
You should type a semicolon ";" at the end of the sql command.
:::

## Example

-- create a table and insert
CREATE TABLE user(name PRIMARY KEY,age NOT NULL);
INSERT INTO user VALUES("Alan",21);
INSERT INTO user VALUES("Yoyo",15);
INSERT INTO user VALUES("David",24);

----------------------------------

-- show all of your tables
ls


###### tags: `python` `sql` `sql shell` `sqlite3`