两条sql语句组合查询
功能:下面代码实现功能为
查询is_deleted为1的id最大的一条记录
根据id,取该记录后面所有数据
sql1 = '''
select max(id) from bilibili_move_house_total_ups_distinct where is_deleted = 1
'''
cursor.execute(sql1)
results1 = cursor.fetchall()
print(results1[0][0])
sql = """
select id, mid from bilibili_move_house_total_ups_distinct where id > %s
"""
cursor.execute(sql, (results1[0][0]))
results = cursor.fetchall()