Home > Article > Backend Development > mysql如何过滤空的数据
mysql如何过滤空的数据
- WBOYOriginal
- 2016-06-13 12:56:432037browse
mysql怎么过滤空的数据
我用is not null怎么不行
过滤里面tit是空的数据
------解决方案--------------------
SELECT * FROM `parts` WHERE partsId='0100000000001' and length(trim(LocationID))0
------解决方案--------------------
把A，B两表的关联换成inner join试试
------解决方案--------------------
is not null or ''
------解决方案--------------------
产生空值是因为AB两表处于全匹配状态，A表里没有，B里有的自然会用null填空
LZ把A，B的匹配用的id列出来，返回去每个表单独查询一下
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article： apache在不同平台上的效率相差很多吗 Next article： php代码如何书写才漂亮