在MySQL Workbench中执行此过程时显示错误

Question

DELIMITER //

CREATE PROCEDURE Sample
BEGIN
    DECLARE v_SQLSTR VARCHAR(800);
    SET v_SQLSTR='Hi';
END;
//
DELIMITER ;

Error Details: Error Code: 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 'BEGIN DECLARE v_SQLSTR VARCHAR(800); SET v_SQLSTR='Hi'; END' at line 2

I am new in MySQL. Please help.

Answer 1

Missed the brackets. Try this: ... CREATE PROCEDURE Sample() ...