python - 在python和sql中从sql中的列中删除所有空值的问题

Question

我有一张表，其中包含对各种项目的评论，其中一些条目为空，因为从中找不到任何内容。所以我尝试在 python 中使用它删除它们，但我收到错误“截断不正确的 DOUBLE 值：'NULL'”。

[测试代码的图像]

[桌子的图像。我需要帮助删除评论列中的所有空列]

标签： pythonsql

Answer 1

When you say = Null it means NULL is just like any other string for example 'car'. Or it is also equal to this:

select 
* , 
'NULL' AS string_null 
from item_info

However, what you are interested in is removing rows that don't have any value which is the dafault nature NULL. To do that use:

DELETE FROM item_info WHERE Reviews_of_item IS NULL