Python 与 SQLite

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)