精華 帝國(guó)PHP系統(tǒng)CMS如何用一句mysql語句實(shí)現(xiàn)多表數(shù)據(jù)之和？

                        <p>很多時(shí)候在用帝國(guó)php系統(tǒng)建站的時(shí)候需要獲取所有數(shù)據(jù)表數(shù)據(jù)的總和，但是又只能用一句mysql語句實(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;

上面語句在帝國(guó)php系統(tǒng)后臺(tái)無法使用，需要做一下修改。

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)單，趕緊收藏起來吧。