How do I create a stored procedure in heidisql?

Question

I'm trying to create a stored procedure in heidisql (mysql).

CREATE PROCEDURE SP_FORM20_POST(
    P_SESSIONID     VARCHAR(256)
)
BEGIN
    INSERT INTO tbForm20
        ( SESSIONID, RegDT)
    VALUES
        ( P_SESSIONID, NOW()); 
END

This is my query. I'm trying to create this procedure, but occur some error:

Error code is 1064

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near'' at line 8".

However, I don't know wrong syntax. What is wrong?

I want to success in heidisql tool. I don't want other db tool. Please help me.

Did you solve this yet? Do you have any feedback on my answer? You are new and have not marked any answers yet with the Green check mark showing the question is answered (if that is the case). — Drew, Jun 24 '16 at 12:52
I'm sorry too late. It still occur same error. So I'm using toad for mysql instead of heidisql. Thank you for your answer. Good day!! — HanTael, Jun 27 '16 at 01:17

score 3 · Answer 1 · answered Sep 15 '16 at 07:58

The problem in that query is the semicolon, which is the default query delimiter.

In order to change the delimiter in HeidiSQL, add the DELIMITER client command above the CREATE PROCEDURE query:

DELIMITER \\
SELECT 1\\
CREATE PROCEDURE ...\\
DELIMITER ;

HeidiSQL also has a procedure designer, with no need to set the delimiter:

score 3 · Answer 2 · edited Aug 23 '20 at 14:41

The problem is this. The database reads the ; in your code as an end of the procedure. You probably don't intend it like that :). The DELIMITER command takes care of that by changing ; to something customizable, like $$. Try this:

DELIMITER $$
CREATE PROCEDURE SP_FORM20_POST(
    P_SESSIONID     VARCHAR(256)
)
BEGIN
    INSERT INTO tbForm20
        ( SESSIONID, RegDT)
    VALUES
        ( P_SESSIONID, NOW()); 
END$$
DELIMITER ;

Surya Gaikwad · Answer 3 · 2019-07-16T11:01:08.260

0

Try this one

DELIMITER //

CREATE PROCEDURE SP_FORM20_POST(
    P_SESSIONID     VARCHAR(256)
)

BEGIN
    INSERT INTO tbForm20
        ( SESSIONID, RegDT)
    VALUES
        ( P_SESSIONID, NOW());

END //

DELIMITER;

edited Jul 16 '19 at 11:01

answered Jul 16 '19 at 10:56

Surya Gaikwad

71
3

How is this answer any different from the most upvoted one? – user1781290 Jul 16 '19 at 11:29
@user1781290 old comment, but this answer sets the delimiter back to `;` while the most upvoted leaves it as `$$`. – Victor Johnson Aug 03 '20 at 06:32

How do I create a stored procedure in heidisql?

3 Answers3