SELECT
CONCAT( SUBSTRING( '2009-01-01 00:00:00', 1, 5 ), '01' ) hours UNION ALL
SELECT
CONCAT( SUBSTRING( '2009-01-01 00:00:00', 1, 5 ), '02' ) UNION ALL
SELECT
CONCAT( SUBSTRING( '2009-01-01 00:00:00', 1, 5 ), '03' ) UNION ALL
SELECT
CONCAT( SUBSTRING( '2009-01-01 00:00:00', 1, 5 ), '04' ) UNION ALL
SELECT
CONCAT( SUBSTRING( '2009-01-01 00:00:00', 1, 5 ), '05' ) UNION ALL
SELECT
CONCAT( SUBSTRING( '2009-01-01 00:00:00', 1, 5 ), '06' ) UNION ALL
SELECT
CONCAT( SUBSTRING( '2009-01-01 00:00:00', 1, 5 ), '07' ) UNION ALL
SELECT
CONCAT( SUBSTRING( '2009-01-01 00:00:00', 1, 5 ), '08' ) UNION ALL
SELECT
CONCAT( SUBSTRING( '2009-01-01 00:00:00', 1, 5 ), '09' ) UNION ALL
SELECT
CONCAT( SUBSTRING( '2009-01-01 00:00:00', 1, 5 ), '10' ) UNION ALL
SELECT
CONCAT( SUBSTRING( '2009-01-01 00:00:00', 1, 5 ), '11' ) UNION ALL
SELECT
CONCAT( SUBSTRING( '2009-01-01 00:00:00', 1, 5 ), '12' )
FROM
DUAL
需要另一个表的话就 2表无关联关系连接 即笛卡尔积连接
小时段 一样