2014/7/24

初学存储过程

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既声明又赋值