Hello, I have a simple SQL query, working from cmd-line, that doesn't work in HeidiSQL 11.2 (and all previous):
SET @x = 20; REPEAT INSERT INTO table(cols) VALUES ('test') SET @x=@x-1 UNTIL @x <= 0 END REPEAT
I get this error:
Errore SQL (1064): 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 serials(serial) VALUES ('10') SET @x=@x-1 U' at line 1
I tried also inserting ";" as delimiter after every line (in almost every combination...), but nothing changes.
This is strange that it's working perfectly in mysql command-line.
Anyone can help? thanks