例如今天,需要的结果是2013-10-23 00:00:00
2013-10-23 00:10:00
2013-10-23 00:20:00
2013-10-23 00:30:00
2013-10-23 00:40:00
2013-10-23 00:50:00
2013-10-23 01:00:00
2013-10-23 01:10:00
2013-10-23 01:20:00
2013-10-23 01:30:00
.
.
.
2013-10-23 23:50:00
2013-10-24 00:00:00
mysql
2013-10-23 00:10:00
2013-10-23 00:20:00
2013-10-23 00:30:00
2013-10-23 00:40:00
2013-10-23 00:50:00
2013-10-23 01:00:00
2013-10-23 01:10:00
2013-10-23 01:20:00
2013-10-23 01:30:00
.
.
.
2013-10-23 23:50:00
2013-10-24 00:00:00
mysql
set @i=1;
set @a=concat(curdate(),' 00:00:00');
while @i<=144 do
insert into lsb values(date_add(@a, interval 10 minute));
set @a=date_add(@a, interval 10 minute);
set @i=@i+1;
end while;
DROP PROCEDURE IF EXISTS tt$$
CREATE PROCEDURE tt()
BEGIN
SET @i=1;
SET @a=CONCAT(CURDATE(),' 00:00:00');
insert into lsb values(date_add(@a, interval 10 minute));
WHILE @i<=144 DO
insert into lsb values(date_add(@a, interval 10 minute));
SET @a=DATE_ADD(@a, INTERVAL 10 MINUTE);
SET @i=@i+1;
END WHILE;
END$$
DELIMITER ;