1) 创建数据库：
sqlite3 test.db
--> SQLite version 3.8.2 2013-12-06 14:53:30
create table Employee(
ID INTERGER PRIMARY KEY,
Name VARCHAR(12)
);
insert into "Employee" values(50000001,"MIKE");
.help
.quit
创建好test.db后，再一次执行sqlite3 test.db不会覆盖上面建立的test.db
2）Python使用
import sqlite3 #cnx = mysql.connector.connect(user='root',password=xxx',host='127.0.0.1',database='test') cnx = sqlite3.connect('/home/xxx/workspace/FourthDj/test.db') cur = cnx.cursor() cur.execute('select * from employee') allRecords = cur.fetchall() print(allRecords)
