文件名:【Python】插入sqlite数据库,微型音箱
【Python】插入sqlite数据库
import sqlite3from datetime
import datetimeconn = sqlite3.connect(
'data.db')print(
"Opened database successfully")for i
in range(100
):time =
datetime.now()conn.execute("INSERT INTO test(time,url,imgPath) VALUES (?,?,?)", (time,
"www.test.com",
"c:/data/" +
str(i)))conn.commit()conn.close()
转载于:https://www.cnblogs.com/tiandsp/p/8504207.html