如何向表中添加行,只有SQL循环并递增日期,例如:
INSERT INTO my_table (the_date) VALUES ('2013-04-13');
INSERT INTO my_table (the_date) VALUES ('2013-04-14');
INSERT INTO my_table (the_date) VALUES ('2013-04-15');
INSERT INTO my_table (the_date) VALUES ('2013-04-16');
...
我需要在2013-05-07之间为下一个例如每天插入一行,例如1000天.
解决方法:
这样的事情会做到: –
INSERT INTO my_table (the_date)
SELECT ADDDATE('2013-04-13', INTERVAL SomeNumber DAY)
FROM (SELECT a.i+b.i*10+c.i*100+d.i*1000 AS SomeNumber FROM integers a, integers b, integers c, integers d) Sub1
WHERE SomeNumber BETWEEN 0 AND 1000
依赖于一个名为整数的表,其中一列名为i,有10行,值从0到9.
Between子句就在那里,因此您可以限制要添加到日期的数字范围
标签:mysql,sql,loops
来源: https://codeday.me/bug/20190620/1245173.html