使用sqlite3 创建和插入数据库,需要注意VALUES(‘%s’) 插入字符如果没有引号会报错
conn.execute('''
CREATE TABLE IF NOT EXISTS CHECK_CODE
(ID integer NOT NULL PRIMARY KEY AUTOINCREMENT ,
MAIL TEXT NOT NULL,
CODE CHAR(4) NOT NULL,
CREATED_TIME VARCHAR(100));
''')
conn.execute('''INSERT INTO CHECK_CODE(MAIL,CODE,CREATED_TIME)
VALUES ("%s","%s","%s");'''%(mail,code,str(time.time())))
conn.commit()
conn.close()