mysql

CREATE EVENT autoDayInsert
ON SCHEDULE EVERY 15 DAYS
    DO
     SET @dayCounter = 0
     WHILE @dayCounter < 15
     BEGIN
     INSERT INTO appointmentDays('day') VALUES(NOW() + INTERVAL @dayCounter day)
     SET @dayCounter = @dayCounter +1
     END
END