精華 帝國(guó)PHP系統(tǒng)CMS如何用一句mysql語(yǔ)句實(shí)現(xiàn)多表數(shù)據(jù)之和?
<p>很多時(shí)候在用帝國(guó)php系統(tǒng)建站的時(shí)候需要獲取所有數(shù)據(jù)表數(shù)據(jù)的總和,但是又只能用一句mysql語(yǔ)句實(shí)現(xiàn),下面這句很實(shí)用。</p>
SELECT COUNT(AA.id) FROM (SELECT id FROM ecms_news UNION ALL SELECT id FROM ecms_xiazai UNION ALL SELECT id FROM ecms_photo UNION ALL SELECT id FROM ecms_download) AA;
上面語(yǔ)句在帝國(guó)php系統(tǒng)后臺(tái)無(wú)法使用,需要做一下修改。
SELECT COUNT(AA.id) as total FROM (SELECT id FROM ecms_news UNION ALL SELECT id FROM ecms_xiazai UNION ALL SELECT id FROM ecms_photo UNION ALL SELECT id FROM ecms_download) AA;
是不是很簡(jiǎn)單,趕緊收藏起來(lái)吧。