mysql 去掉查询格式化_mysql数据库查询的格式化

DROP TEMPORARY TABLE IF EXISTS TABLE_1;

CREATE TEMPORARY TABLE TABLE_1

(

SELECT *

FROM

(

SELECT '100YUAN' vMoney,'5REN' vNum,'2015-09-15' vDate

UNION ALL

SELECT '200YUAN','6REN','2015-09-21'

)a

);

DROP TEMPORARY TABLE IF EXISTS TABLE_2;

CREATE TEMPORARY TABLE TABLE_2

(

SELECT *

FROM

(

SELECT '2015-09-15' vDate

UNION ALL

SELECT '2015-09-16'

UNION ALL

SELECT '2015-09-17'

UNION ALL

SELECT '2015-09-18'

UNION ALL

SELECT '2015-09-19'

UNION ALL

SELECT '2015-09-20'

UNION ALL

SELECT '2015-09-21'

UNION ALL

SELECT '2015-09-22'

UNION ALL

SELECT '2015-09-23'

UNION ALL

SELECT '2015-09-24'

) a

);

SELECT a.vDate,IFNULL(b.vMoney,0) vMoney,IFNULL(b.vNum,0) vNum

FROM TABLE_2 a

LEFT JOIN TABLE_1 b ON a.vDate = b.vDate

ORDER BY a.vDate