navicate how to create a stored procedure

来源:互联网 发布:c语言 semctl 编辑:程序博客网 时间:2024/04/29 17:26
你打开"new query",然后直接在新的窗口里编写就可以了,给你个示例:create procedure p_test(in i_num int,in i_name varchar(50),out o_result varchar(100))begin  select i_num as '输入参数1', i_name as '输入参数2';  set o_result = '输入参数结果为:';end;