python之sqlite数据库

import sqlite3
conn = sqlite3.connect('test.sqlite')#建一个库或连接一个数据库
print ("Opened database successfully")
c = conn.cursor()
c.execute('''CREATE TABLE COMPANY
       (ID INT PRIMARY KEY     NOT NULL,
       NAME           TEXT    NOT NULL,
       AGE            INT     NOT NULL,
       ADDRESS        CHAR(50),
       SALARY         REAL);''')#建一张表
c.execute("INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) VALUES (1, 'Paul', 32, 'California', 20000.00 )")
                                #写如一条数据
cursor = c.execute("SELECT id, name, address, salary  from COMPANY")
                                #读取一条数据
for row in cursor:
   print ("ID = ", row[0])
   print ("NAME = ", row[1])
   print ("ADDRESS = ", row[2])
   print ("SALARY = ", row[3], "\n")
print ("Table created successfully")
conn.commit()#提交
conn.close()#关闭

CREATE TABLE salespeople (
  id INTEGER PRIMARY KEY,
  first_name TEXT NOT NULL,
  last_name TEXT NOT NULL,
  commission_rate REAL NOT NULL
);
主键如果是INTEGER ，默认就是增长类型，其他字段可以通过申明AUTOINCREMENT ，但是最好不要这样做，因为自动增长主要是为主键设置的