null和空字符串是有区别的
不为null的写法:
where a.is_view is not null
不为空的写法
where a.reply <> ''
注:
https://www.cnblogs.com/fnlingnzb-learner/p/6519731.html
http://www.splaybow.com/post/mysql-sql-where-is-not-null.html
null和空字符串是有区别的
不为null的写法:
where a.is_view is not null
不为空的写法
where a.reply <> ''
注:
https://www.cnblogs.com/fnlingnzb-learner/p/6519731.html
http://www.splaybow.com/post/mysql-sql-where-is-not-null.html