初学存储过程 DELIMITER // 定义写存储过程中的结束符为 // 创建存储过程 1: create procedure proce_userinfo(in name varchar(10) ,int pwd varchar(10),out flag int) begin select power from user where Username=name and password=pwd into flag; end
初学存储过程
DELIMITER // 定义写存储过程中的结束符为 //
创建存储过程 1:
- create procedure proce_userinfo(in name varchar(10) ,int pwd varchar(10),out flag int)
- begin
- select power from user where Username=name and password=pwd into flag;
- end //
创建存储过程 2:
- create procedure proc_reg(in name varchar(10),in pwd varchar(10),out flag int)
- begin
- set @count=0;
- select count(*) from users where username=name into @count;
- if @count>0 then
- set flag=0;
- else
- set flag=1;
- insert into users(username,passwords)values (name,pwd);
- end if;
- end
declare 只是声明, set 既声明又赋值
来源: https://www.php1.cn/detail/php-baa2ee6699.html