Python之Sqlitespy中选出两表中以id相同的元素

# 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