查询:
mysql>select column_name from table_name where column_name is null;
删除:
mysql>delete from table_name where column_name is null;
不能使用where column_name=null,因为该计算返回的结果为null,即删除语句不会执行。
查询:
mysql>select column_name from table_name where column_name is null;
删除:
mysql>delete from table_name where column_name is null;
不能使用where column_name=null,因为该计算返回的结果为null,即删除语句不会执行。