sql = "SELECT area_id,area_name FROM `t_area_info` WHERE area_id IN ({mark})".format(
mark=','.join(["%s"] * 1000))
with conn.cursor() as cursor:
new_sql = sql % tuple(value_list) #需要将value_list 转化为tuple
cursor.execute(new_sql)
sql = "SELECT area_id,area_name FROM `t_area_info` WHERE area_id IN ({mark})".format(
mark=','.join(["%s"] * 1000))
with conn.cursor() as cursor:
new_sql = sql % tuple(value_list) #需要将value_list 转化为tuple
cursor.execute(new_sql)