1. 修改字段为NULL
1
|
update
tableName
set
column1
=
null
where
id = 1
|
2. 字段是否为NULL
(1)字段为空
1
|
select
* tableName
where
column1
is
null
|
(2)字段不为空
1
|
select
* tableName
where
column1
is
not
null
|