mysql 两个表删除数据库_mysql 数据库 删除两个表之间的差集

flag= False

while not flag:

try:

# for line in readfile(txt_path + "8.txt")[322:]:  # (323)        858

#    line = line.split("\t")

#    Novel_pid = line[0]

#    Novel_name = line[1]

#    print(Novel_pid,Novel_name)

db= pymysql.connect('27.255.79.21','user','*****!','db_qishu',charset="utf8")

cursor= db.cursor()

#sql = "select Novel_ID from `qishu_books_sort08` WHERE Novel_pid = %s;"%Novel_pid

sql= "select Novel_ID from `qishu_books_sort08` WHERE Novel_pid = 323;"

cursor.execute(sql)

Novel_list= cursor.fetchall()

print(len(Novel_list))

i= 0

for Novel_IDin Novel_list:

Novel_ID= Novel_ID[0]

print(Novel_ID,str(i))

i+= 1

sql= "UPDATE qishu_books_sort08 SET Novel_ID_Count = %s WHERE Novel_ID = %s"%(i,Novel_ID)

cursor.execute(sql)

db.commit()

except Exception as ex:

print(Exception,":", ex)

flag= True