初学存储过程

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