None null mysql_在Python中将None作为Null传递给MySQL

我有样品：args["test"] = None

try:

with self.connection.cursor(MySQLdb.cursors.DictCursor) as cursor:

cursor.callproc('mystoredproc',[str(args["test"])])

self.connection.commit()

result = {"status": True, "reason": "", "result": json.loads(json.dumps(cursor.fetchone(), cls=DateTimeEncoder))}

except (MySQLdb.Error, MySQLdb.Warning) as e:

print("ERROR: {}".format(e))

result = {"status": False, "reason": "Insert Failed", "result": "ERROR: {}".format(e)}

finally:

# self.DestroyConnection()

pass

问题很简单：

我怎么把上面的“无”作为空值传递？

是否可以不转换值？在

因为如果我运行该代码，它会返回我：ERROR: (1366, "Incorrect decimal value: 'None' for column 'test' at

row 1")

它假设在DB中将值设置为NULL

谢谢！在