pymsql的delete操作无效
sql = f"DELETE FROM {table} WHERE {x_col} <= {eval(config['MAP']['point_left'])} OR " \
f"{x_col} >= {eval(config['MAP']['point_right'])}"
# 执行操作
db.execute(sql)
# 向数据库提交操作
conn.commit()
print(f"已经删除了{db.rowcount}行数据")
>>>sql 'DELETE FROM 总订单数据 WHERE ON_LON <= 108.88503964800009 OR ON_LON >= 108.99195566800006'