|
![](static/image/common/ico_lz.png)
楼主 |
发表于 2016-12-18 13:49:43
|
显示全部楼层
长度 个数都没有限制, 是语法问题, 在CI中UNION要求必须所有表字段一致
(SELECT a.title, a.url, a.description, a.updatetime FROM dr_1_whdt AS a, dr_1_whdt_flag AS b WHERE a.id = b.id AND b.flag=9) UNION
(SELECT a.title, a.url, a.description, a.updatetime FROM dr_1_fybl AS a, dr_1_fybl_flag AS b WHERE a.id = b.id AND b.flag=9) UNION
(SELECT a.title, a.url, a.description, a.updatetime FROM dr_1_fyxy AS a, dr_1_fyxy_flag AS b WHERE a.id = b.id AND b.flag=9) UNION
(SELECT a.title, a.url, a.description, a.updatetime FROM dr_1_zhy AS a, dr_1_zhy_flag AS b WHERE a.id = b.id AND b.flag=9) UNION
(SELECT a.title, a.url, a.description, a.updatetime FROM dr_1_whmc AS a, dr_1_whmc_flag AS b WHERE a.id = b.id AND b.flag=9) UNION
(SELECT a.title, a.url, a.description, a.updatetime FROM dr_1_whdl AS a, dr_1_whdl_flag AS b WHERE a.id = b.id AND b.flag=9) UNION
(SELECT a.title, a.url, a.description, a.updatetime FROM dr_1_mjmz AS a, dr_1_mjmz_flag AS b WHERE a.id = b.id AND b.flag=9)
ORDER BY updatetime DESC LIMIT 2
这样就通过了,也许是mysql严格模式问题
|
|