关于MySQL存储过程中遇到的一个错误

查询：create procedure test1(out var varchar(200)) comment ‘操作变量‘ begin set var=‘MySQL%Orcle%DeLL%IBM‘; select replace(var,‘%‘...

共 0 行受到影响

执行耗时 : 0 sec
传送时间 : 0.064 sec
总耗时 : 0.065 sec
--------------------------------------------------

查询：delimiter;


错误代码： 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 ‘delimiter‘ at line 1

DELIMITER //
CREATE PROCEDURE test1(OUT var VARCHAR(200))
COMMENT ‘操作变量‘
BEGIN
    
    SET var=‘MySQL%Orcle%DeLL%IBM‘;
    SELECT REPLACE(var,‘%‘,‘|‘) INTO var;

END
//
DELIMITER;