Re: Exception: DELIMITER //

[Rafal Somla]

Hi,

MySQL client DELIMITER command is not part of SQL language. This is just a directive which tells MySQL client how to detect end of statements. But when using connector this is not needed, because SQL queries are given as strings and it is clear where they end. Thus, when using connector API, you can simply use ';' inside stored procedure body and there is no confusion. For example this works as expected:
~~~~~~
s.sql(R"(
CREATE PROCEDURE test.dorepeat(p1 INT)
BEGIN
SET @x = 0;
REPEAT SET @x = @x + 1; UNTIL @x > p1 END REPEAT;
END
)").execute();
~~~~~~