1.示例1 查询1: SELECT CASE main_xm_sam31 WHEN '02' THEN 2 ELSE 1 END AS SPDJ FROM SR_MAIN_BG A WHERE A.PK_SR_MAIN = '1162275825622593536' AND (SYS_SPDJ = 0 OR SYS_SPDJ = -1) 查询2: SELECT count(1) AS ncount, ( CASE sys_sjbj WHEN 0 THEN '个人发布' WHEN 1 THEN '
MySQL存储过程 CASE语句 除了IF语句,MySQL提供了一个替代的条件语句CASE. MySQL CASE语句使代码更加可读和高效. CASE语句有两种形式:简单的搜索CASE语句. 简单CASE语句 我们来看一下简单CASE语句的语法: CASE case_expression WHEN when_expression_1 THEN commands WHEN when_expression_2 THEN commands ... ELSE commands END CASE; 您可
MySQL 存储过程 ```sql CREATE PROCEDURE myprocedure (IN para01 INTEGER) BEGIN DECLARE var01 CHAR(10); IF para01 = 17 THEN SET var01 = 'birds'; ELSE SET var01 = 'beasts'; END IF; INSERT INTO table1 VALUES(var01); END ``` 创建实例 ```sql CREATE PROCEDURE p1 /*声
变量作用域内部的变量在其作用域范围内享有更高的优先权,当执行到end.变量时,内部变量消失,此时已经在其作用域外,变量不再可见了,应为在存储过程外再也不能找到这个申明的变量,但是你可以通过out参数或者将其值指派给会话变量来保存其值. mysql > DELIMITER // mysql > CREATE PROCEDURE proc3() -> begin -> declare x1 varchar() default 'outer'; -> begin -> dec
一口气弄完了! 一.条件语句if-then-else: create procedure demo_1(in param int) begin declare var int; ; then insert into userinfo(name) values('demo'); else insert into userinfo(name) values('demo'); end if; then update userinfo set age=param where name='demo'; e
Mysql存储过程知识,案例: create procedure delete_setting(in p_settingid integer) begin delete from setting where settingid=p_settingid; end select `name` from mysql.proc where db = 'your_db_name' and `type` = 'PROCEDURE' show procedure status; show create pro