SELECT dir3.url from dir3 LEFT JOIN dir4 on dir4.url=dir3.url where dir4.id is null or dir3.md5<>dir4.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.md5<>dir4.md5 and dir3.inputtime=1453086000为一列
希望大神帮忙,在线等
SELECT dir3.url as url1,'' as url2 from dir3 LEFT JOIN dir4 on dir4.url=dir3.url where dir4.id is null and dir3.inputtime=1453086000
union all
SELECT '' as url1,dir3.url as url2 from dir3 LEFT JOIN dir4 on dir4.url=dir3.url dir3.md5<>dir4.md5 and dir3.inputtime=1453086000
SELECT group_concat(url1 separator ''),group_concat(url2) FROM (
SELECT @CNT:=@CNT+1 rownum,dir3.url as url1,'' as url2 from dir3 LEFT JOIN dir4 on dir4.url=dir3.url where dir4.id is null and dir3.inputtime=1453086000,(select @cnt:=0) r
union all
SELECT @CNT1:=@CNT1+1 rownum,'' as url1,dir3.url as url2 from dir3 LEFT JOIN dir4 on dir4.url=dir3.url dir3.md5<>dir4.md5 and dir3.inputtime=1453086000,(select @cnt1:=0) r1
) A group by rownum