做echart的图形接口,需要将不同的表联合查询,并且在一个接口中返回。

SELECT SUM(f_jfje) AS VALUE,'年检' AS NAME FROM F_NJDJ
UNION ALL 
SELECT SUM(f_zfy) AS VALUE,'维保' AS NAME FROM F_WBQC
UNION ALL 
SELECT SUM(F_BXFY) AS VALUE,'保险' AS NAME FROM F_BXDJ

返回结果

mysql多张表联合统计并返回-LMLPHP

07-31 21:53