Home >Database >Mysql Tutorial >mysql多个条件分列显示的问题
mysql多个条件分列显示的问题
- WBOYOriginal
- 2016-06-06 09:34:291635browse
mysql
SELECT dir3.url from dir3 LEFT JOIN dir4 on dir4.url=dir3.url where dir4.id is null or dir3.md5dir4.md5 and dir3.inputtime=1453086000
现在这条语句，把两个条件的结果都显示在一列
因为我需要分开处理，所以希望能改成两列显示
SELECT dir3.url from dir3 LEFT JOIN dir4 on dir4.url=dir3.url where dir4.id is null and dir3.inputtime=1453086000为一列
SELECT dir3.url from dir3 LEFT JOIN dir4 on dir4.url=dir3.url dir3.md5dir4.md5 and dir3.inputtime=1453086000为一列
希望大神帮忙，在线等
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：mysql-初学JDBC连接MYSQL数据库，出现一个异常，求教，在线等Next article：mysql-MySQL安装出错，总是到Start Server就失败了