python怎么往数据库插null,如何使用Python将NULL数据插入MySQL数据库？

机智的大群主

于 2020-12-10 08:47:51 发布

阅读量556

点赞数

文章标签： python怎么往数据库插null

本文介绍了一种在Python脚本中向MySQL数据库插入数据时遇到的问题：当尝试插入空白变量时，MySQL会报错。文章提供了解决方案，即如何将空白变量转换为NULL进行插入，同时确保数据完整性和分析准确性不受影响。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

I'm getting a weird error when inserting some data from a Python script to MySQL. It's basically related to a variable being blank that I am inserting. I take it that MySQL does not like blank variables but is there something else I can change it to so it works with my insert statement?

I can successfully use an IF statement to turn it to 0 if its blank but this may mess up some of the data analytics I plan to do in MySQL later. Is there a way to convert it to NULL or something so MySQL accepts it but doesn't add anything?

解决方案

Do a quick check for blank, and if it is, set it equal to NULL:

if(!variable_to_insert)

variable_to_insert = "NULL"

...then make sure that the inserted variable is not in quotes for the insert statement, like:

insert = "INSERT INTO table (var) VALUES (%s)" % (variable_to_insert)

...

not like:

insert = "INSERT INTO table (var) VALUES ('%s')" % (variable_to_insert)

...