# coding=UTF-8
import sqlite3
from xlsxwriter.workbook import Workbook
# 传出到下列文本1st.xlsx不用新建,自己建
workbook = Workbook('C:/Users/ROCKXU/Desktop/5st.xlsx')
worksheet = workbook.add_worksheet()
# 传入数据库路径,db.s3db或者test.sqlite
conn=sqlite3.connect('C:/Users/ROCKXU/Desktop/A2/QS.db3')
c=conn.cursor()
mysel=c.execute("select * from test3 where id in(select id from jihe2)")
# 选出来的是两者中相同的部分且是test3表的内容
for i, row in enumerate(mysel):
for j, value in enumerate(row):
worksheet.write(i, j, value)
workbook.close()
# insert into test (keyd,id) VALUES(8,3)
# select * from table1 where id in(select id from table2)
# create table test3(keyd int(18),id int(3))
# drop table test
# CREATE TABLE newTb AS SELECT * FROM oldTb
Python之Sqlitespy中选出两表中以id相同的元素
最新推荐文章于 2022-07-02 23:58:32 发布