sql----用if...then...elseif...,,,2.用case...when...then...
来源:互联网 发布:淘宝怎么加入一淘条件 编辑:程序博客网 时间:2024/05/01 05:52
下面的應用有使用參數
1.用if...then...elseif...
DELIMITER $$
DROP PROCEDURE IF EXISTS `demodb`.`sp2` $$
CREATE PROCEDURE `sp2`(in pid varchar(10))
begin
/*declare strsql varchar(100); */
if pid="1" then prepare stmt from 'select * from tablea ';
elseif pid="2" then prepare stmt from 'select * from tableb' ;
else prepare stmt from 'select * from tablec' ;
end if ;
/*prepare stmt from strsql; */
execute stmt ;
end $$
DELIMITER ;
2.用case...when...then...
上面begin...end中的可以用case改寫,如下:
BEGIN
/*DECLARE strsql varchar(100);*/
CASE pid
when "1" then prepare stm from "select * from tablea";
when "2" then prepare stm from "select * from tableb";
when "3" then prepare stm from "select * from tablec";
else prepare stm from "select * from tabled";
END CASE;
EXECUTE stm;
3.1的簡化式:
if pid="1" then set @sql= 'select * from tablea '; elseif pid="2" then set @sql='select * from tableb' ; else set @sql='select * from tablec' ; end if ;
prepare stmt from @sql;
execute stmt ;
4.2的簡化式:
CASE pid
when "1" then set @sql="select * from tablea";
when "2" then set @sql="select * from tableb";
when "3" then set @sql="select * from tablec";
else set @sql="select * from tabled";
END CASE;
prepare stm from @sql;
EXECUTE stm;
DECLARE strsql varchar(100);
CASE pid
when "1" then set strsql="select * from tablea";
when "2" then set strsql="select * from tableb";
when "3" then set strsql="select * from tablec";
else set strsql="select * from tabled";
END CASE;
select strsql;
- sql----用if...then...elseif...,,,2.用case...when...then...
- sql --case when then
- sql case when then
- sql case when then
- sql中的case、when、then
- SQL之 case when then
- sql--case when then 示例
- sql case when then 语法
- sql case when then else
- SQL行转列(case when then )
- pl/sql case when then
- sql中case when then
- SQL之CASE,WHEN,THEN
- SQL之CASE,WHEN,THEN
- sql count case when 0 then
- sql中case when then使用实例
- case when then else SQL语句
- case when then else SQL语句
- 3-(E-teller)使用SQL语句
- 开发出具有良好的视觉效果的应用程序
- Osip2和eXosip协议栈的简析(转载)
- Windows 启动方式总结归纳&HIPS注册表防护关键位置
- sqlserver 海量数据导入的最快方法
- sql----用if...then...elseif...,,,2.用case...when...then...
- Visual C++.NET编程(1)
- MySql与Java的时间类型
- 关于ModifyStyle
- loadimage的问题!!!
- ASSERT函数(转贴 )
- Heritrix使用的初步总结
- Bestcomy.Web.Controls.Upload 组件支持多文件上传
- Rails Cookbook读书笔记之-Understanding Pluralization Patterns in Rails