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
初学存储过程
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既声明又赋值
推荐阅读
-
Centos7 Yum方式安装Mysql7
-
windows7安装laravel homestead后,卡在SSH auth method: private key
-
Microsoft SQL Server 2008安装图解教程(Windows 7)
-
Css样式兼容IE6,IE7,FIREFOX的写法_html/css_WEB-ITnose
-
PHP学习笔记7:错误和异常处理
-
angular2-7中的变化监测
-
IE6、IE7中获取Button元素的值的bug说明_javascript技巧
-
推荐7款用于PHP的代码调试工具
-
No plugin found for prefix 'tomcat7'解决方案
-
CentOS 6安装Nginx centos nginx 启动 centos6.5 nginx centos7 安装 ngin