请提供采用PYMYSQL库在MYSQL数据库A的B表中依次按条件1条件2条件3条件4进行数据寻找的python代码，条件1为温度在20到25之间、条件2为水分在14到17之间、条件3为流量在480到520之间、条件4为标偏在0.2-0.3之间，返回的数据在写入表C之前需先查询表C是否存在，存在就直接将数据写入表C，不存在则先新建表C再将数据写入表C中

以下是使用PYMYSQL库在MYSQL数据库A的B表中依次按条件1条件2条件3条件4进行数据寻找的python代码：

import pymysql

# 连接数据库
conn = pymysql.connect(host='localhost', port=3306, user='root', password='123456', db='A', charset='utf8')

# 获取游标
cursor = conn.cursor()

# 查询表C是否存在
cursor.execute("show tables like 'C'")
result = cursor.fetchone()

# 如果表C不存在，则创建表C
if not result:
    cursor.execute("CREATE TABLE C (id INT PRIMARY KEY AUTO_INCREMENT, temperature FLOAT, humidity FLOAT, flow_rate FLOAT, bias FLOAT)")

# 依次按条件1条件2条件3条件4进行数据寻找
cursor.execute("SELECT * FROM B WHERE temperature BETWEEN 20 AND 25 AND humidity BETWEEN 14 AND 17 AND flow_rate BETWEEN 480 AND 520 AND bias BETWEEN 0.2 AND 0.3")
results = cursor.fetchall()

# 将数据写入表C
for row in results:
    cursor.execute("INSERT INTO C (temperature, humidity, flow_rate, bias) VALUES (%s, %s, %s, %s)", (row[0], row[1], row[2], row[3]))

# 提交事务
conn.commit()

# 关闭游标和连接
cursor.close()
conn.close()