mysql创建日历表

CREATE PROCEDURE createDate()
begin
	declare indexdate DATE;
	set indexdate = DATE('2017-01-01');
	while indexdate <= DATE('2027-12-31')
	do
		insert into ab_date(date) values(indexdate);
		set indexdate = ADDDATE(indexdate,1) ;
	end while;
end;

CALL createDate()