SQL语句嵌套if
2024-08-24 11:49:12
在存储过程中我要实现一个IF的嵌套语句查询,类似与
if()
{
if()
{
......
}
else
{
......
}
}
else
{
......
}
请问这样的SQL语句要怎么写啊?
create
procedure
`test2`
(
IN
cusername <a href=
"https://www.baidu.com/s?wd=VARCHAR&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1dWPj6knWw9PvDzPAc4nH0z0ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6K1TL0qnfK1TL0z5HD0IgF_5y9YIZ0lQzqlpA-bmyt8mh7GuZR8mvqVQL7dugPYpyq8Q1D3rjnYnWbYnHDzPjmzrHTkPj6"
target=
"_blank"
class=
"baidu-highlight"
>
VARCHAR
</a>(50),
IN
cpassword <a href=
"https://www.baidu.com/s?wd=VARCHAR&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1dWPj6knWw9PvDzPAc4nH0z0ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6K1TL0qnfK1TL0z5HD0IgF_5y9YIZ0lQzqlpA-bmyt8mh7GuZR8mvqVQL7dugPYpyq8Q1D3rjnYnWbYnHDzPjmzrHTkPj6"
target=
"_blank"
class=
"baidu-highlight"
>
VARCHAR
</a>(50),
IN
clastloginio <a href=
"https://www.baidu.com/s?wd=VARCHAR&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1dWPj6knWw9PvDzPAc4nH0z0ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6K1TL0qnfK1TL0z5HD0IgF_5y9YIZ0lQzqlpA-bmyt8mh7GuZR8mvqVQL7dugPYpyq8Q1D3rjnYnWbYnHDzPjmzrHTkPj6"
target=
"_blank"
class=
"baidu-highlight"
>
VARCHAR
</a>(50)
)
BEGIN
if exists(
select
*
from
mt_userlogin
where
username=cusername)
then
-- if exists(select 1) then
if(1=1)
THEN
select
1;
<a href=
"https://www.baidu.com/s?wd=ELSE&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1dWPj6knWw9PvDzPAc4nH0z0ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6K1TL0qnfK1TL0z5HD0IgF_5y9YIZ0lQzqlpA-bmyt8mh7GuZR8mvqVQL7dugPYpyq8Q1D3rjnYnWbYnHDzPjmzrHTkPj6"
target=
"_blank"
class=
"baidu-highlight"
>
ELSE
</a>
select
2;
end
if;
<a href=
"https://www.baidu.com/s?wd=ELSE&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1dWPj6knWw9PvDzPAc4nH0z0ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6K1TL0qnfK1TL0z5HD0IgF_5y9YIZ0lQzqlpA-bmyt8mh7GuZR8mvqVQL7dugPYpyq8Q1D3rjnYnWbYnHDzPjmzrHTkPj6"
target=
"_blank"
class=
"baidu-highlight"
>
ELSE
</a>
select
-7,
'Username not found'
;
end
if;
end
;
最新文章
- 如何根据执行计划,判断Mysql语句是否走索引
- MySQL Cluster 数据分布(分区、分组)
- Java 实现函数回调
- 超简单的JNI——NDK开发教程
- python学习心得第一章
- Selenium&;EmguCV实现爬虫图片识别
- 【POJ】1062 昂贵的聘礼(spfa)
- Linux 性能工具 - sar学习
- 位置式PID与增量式PID算法
- MySQL for Windows 解压缩版配置安装
- 【MySQL】unique列插入重复值解决方案
- 让文字在标签li的底部
- 【VB技巧】VB静态调用与动态调用dll详解
- java 成员访问修饰符
- 在JAVA中使用LUA脚本记,javaj调用lua脚本的函数(转)
- Unity使用Mono.Xml代替System.Xml 测试
- 生物结构变异分析软件meerkat 0.189使用笔记(二)
- python multiprocessing example
- scrapy分布式爬虫scrapy_redis一篇
- js点击加载更多可以增加几条数据的显示