php - 在 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

我是 MySQL 的新手。请帮忙。

Answer 1

错过了括号。尝试这个:...创建程序样本()...