xwb1989 / sqlparser

SQL Parser implemented in Go
Apache License 2.0
1.47k stars 238 forks source link

How to parse SQL procedure CALL #70

Open Delicious-Bacon opened 2 years ago

Delicious-Bacon commented 2 years ago

I have an SQL procedure in MariaDB called bookUPDATE such as this:

BEGIN
    UPDATE book
        SET
            book.Title= v_Title,
            book.ReleaseDate = v_ReleaseDate,
            book.Description = v_Description,
        WHERE book.ID = v_ID;
END

I have an SQL builder for this procedure which creates a string:

q := "CALL bookUPDATE(?, ?, ?, ?); CALL bookUPDATE(?, ?, ?, ?);"

When I do the sqlparser.Parse(q) I get an error syntax error at position 5 near 'call'.

How am I supposed to Parse calling the procedure?