我写的下面脚本,
CREATE PROCEDURE UP_user_role_ADD
(
in @role_name varchar(50),
in @re varchar(200)
)
begin
INSERT INTO user_role(
role_name,
re
)VALUES(
@role_name,
@re
)
end
在EMS SQL Manager 2007 for MySQL这个工具里执行时,提示错误,这是什么问题??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 '@role_name varchar(50),
in @re varchar(200)
)
begin
INSERT INTO user_role(' at line 3
CREATE PROCEDURE UP_user_role_ADD
(
in @role_name varchar(50),
in @re varchar(200)
)
begin
INSERT INTO user_role(
role_name,
re
)VALUES(
@role_name,
@re
)
end
在EMS SQL Manager 2007 for MySQL这个工具里执行时,提示错误,这是什么问题??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 '@role_name varchar(50),
in @re varchar(200)
)
begin
INSERT INTO user_role(' at line 3
in re varchar(200)
(
in role_name varchar(50),
in re varchar(200)
)
(
in role_name varchar(50),
in re varchar(200)
)
begin
INSERT INTO user_role(
role_name,
re
)VALUES(
@role_name,
@re
)
end
还有一个错误
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 'end' at line 14
(
in role_name varchar(50),
in re varchar(200)
)
begin
INSERT INTO user_role(
role_name,
re
)VALUES(
@role_name,
@re
);
END$$DELIMITER ;
(
in role_name varchar(50),
in re varchar(200)
)
begin
INSERT INTO user_role(
role_name,
re
)VALUES(
role_name,
re
);
END$$DELIMITER ;
(
in role_name varchar(50),
in re varchar(200)
)
begin
INSERT INTO user_role(
role_name,
re
)VALUES(
@role_name,
@re
);
end;