python和sqlite_Python 与 SQLite

Lite:清淡的, 低盐的轻，清淡：相比其他事物内容较少，重量较轻或卡路里含量较低

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)