无法将无值从python发送到mysql的浮点型字段

import MySQLdb

# 连接数据库
conn = MySQLdb.connect(host='localhost', user='root', password='password', db='database_name')

# 创建游标对象
cursor = conn.cursor()

# 定义插入语句
sql = "INSERT INTO table_name (float_field) VALUES (%s)"

# 将None作为参数传递给execute()方法
cursor.execute(sql, (None,))

# 提交事务
conn.commit()

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

import pymysql

# 连接数据库
conn = pymysql.connect(host='localhost', user='root', password='password', db='database_name')

# 创建游标对象
cursor = conn.cursor()

# 定义插入语句
sql = "INSERT INTO table_name (float_field) VALUES (%s)"

# 将None作为参数传递给execute()方法
cursor.execute(sql, (None,))

# 提交事务
conn.commit()

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