我有一张表t_calendar的字段:(需要向表中插入如下3000多条数据)
ID START_DATE END_DATE START_TIME END_TIME
1 20120501 20120502 7:00 6:00
2 20120502 20120503 7:00 6:00
3 20120503 20120504 7:00 6:00
4 20120504 20120505 7:00 6:00
5 20120505 20120506 7:00 6:00
......
3000 20200201 20200202 7:00 6:00
请问这条sql语句应该如何写?感谢各位!
------解决方案--------------------------------------------------------
BEGIN ATOMIC DECLARE i INT DEFAULT 0; WHILE (i<3000) DO INSERT INTO T_CALENDAR VALUES(i+1,replace(char(date('2012-05-01')+i days),'-',''),replace(char(date('2012-05-01')+(i+1) days),'-',''),'7:00','6:00'); SET i=i+1; END WHILE; END