"空值"是对null值的中文叫法。
null值其数据类型是未知的,它不会占用物理磁盘空间
空字符串即 存储"零长度字符串"是要占用物理磁盘空间的;
至于MYSQL 查询出来的null 或者 “”动手查询看效果。
select * from cms_info where TITLEPREFIX is null;
select * from cms_info where TITLEPREFIX is not null;
select * from cms_info where TITLEPREFIX = “”;
null值其数据类型是未知的,它不会占用物理磁盘空间
空字符串即 存储"零长度字符串"是要占用物理磁盘空间的;
至于MYSQL 查询出来的null 或者 “”动手查询看效果。
select * from cms_info where TITLEPREFIX is null;
select * from cms_info where TITLEPREFIX is not null;
select * from cms_info where TITLEPREFIX = “”;
select * from cms_info where TITLEPREFIX <> “”;