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;
//

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