import sqlite3
con=sqlite3.connect(':memory:')
query="""CREATE TABLE sales(uname VARCHAR(20),salary FLOAT,datatime DATE);"""
con.execute(query)
con.commit()
data=[('李四',12000.0,'2019-03-15 14:28:21'),
('李四',13344.0,'2019-03-15 14:23:01'),
('李四',12324.0,'2019-03-15 14:23:22'),
('李四',12324.0,'2019-03-15 14:28:21'),
('王五',10000.0,'2019-03-15 14:28:23'),
('王五',3344.0,'2018-03-15 14:28:24'),
('王五',33244.0,'2018-03-15 14:28:25'),
('张三',93244.0,'2018-03-15 14:28:20'),
('张三',3244.0,'2019-03-15 14:28:28'),
('张三',1244.0,'2019-03-15 14:28:27'),
('张三',2244.0,'2019-03-15 14:28:29')]
statement='INSERT INTO sales VALUES(?,?,?)'
con.executemany(statement,data)
con.commit()
cursor=con.execute('SELECT MAX(salary) FROM sales')
cursor2=con.execute('SELECT SUM(salary) FROM sales')
rows=cursor.fetchall()
rows2=cursor2.fetchall()
print(rows)
print(rows2)
python 向数据库写入数据
最新推荐文章于 2023-06-03 13:31:48 发布