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()