1.存储过程
(1)定义过程时,使用 DELIMITER $$ 命令将语句的结束符号从分号 ; 临时改为两个 $$,使得过程体中使用的分号被直接传递到服务器,而不会被客户端(如mysql)解释。
delimiter $$
create procedure find(in num1 int)
begin
select * from student where stuno = num1;
end$$
delimiter ;
call find(1);
delimiter $$
create procedure add_three_num(in num1 int,in num2 int,in num3 int,out re int)
begin
set re = num1+num2+num3;
end$$
delimiter ;
2.存储函数
(1)建立存储函数的时候报错 “This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable) ”,打开my.ini,添加上 log_bin_trust_function_creators=1
delimiter $$
create function add_twonum_function(a int,b int,c int) returns int
begin
return a+b+c;
end$$
d