why isn't this procedure working?
i'm trying to fill a calendar with a bunch of dates so i can reference it from another table to see what dates are missing.
if you could, include the syntax to create a new table in case i messed up that as well.
i used this last time: CREATE Table Calendar(dt date not null);
ysql> create procedure fillcalendar()
-> SET @x = '2000-01-01'
-> INSERT INTO Calendar(dt) VALUES (@x)
-> SET @x = @x + 1
-> UNTIL @x > '2000-12-31'
-> end repeat
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'repeat
INSERT INTO Calendar(dt) VALUES (@x)
SET @x = @x + 1
UNTIL @x > '2000-12-' at line 4