mysql function 语法错误_MySQL创建函数报语法错误如何解决

例如

create PROCEDURE insert_address(

in p_name varchar(30),

in p_phone varchar(30),

in p_address varchar(100),

in p_uid int(10),

in p_def int(3)

)

BEGIN

INSERT into t_address(name,phone,address,uid,def)

VALUES(p_name,p_phone,p_address,p_uid,p_def);

END;

毫无错误，但就是报了一个错误

create PROCEDURE insert_address(

in p_name varchar(30),

in p_phone varchar(30),

in p_address varchar(100),

in p_uid int(10),

in p_def int(3)

)

BEGIN

INSERT into t_address(name,phone,address,uid,def)

VALUES(p_name,p_phone,p_address,p_uid,p_def)

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 '' at line 10

时间: 0s

解决：

用 delimiter //    // 包起来

效果如下

delimiter //

create PROCEDURE insert_address(

in p_name varchar(30),

in p_phone varchar(30),

in p_address varchar(100),

in p_uid int(10),

in p_def int(3)

)

BEGIN

INSERT into t_address(name,phone,address,uid,def)

values(p_name,p_phone,p_address,p_uid,p_def);

END;

//

就能创建成功了，找到函数，右键刷新一下就有了