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 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