让我们首先看看 mysql 中 if not in 的语法 -
if(yourvariablename not in (yourvalue1,yourvalue2,........n) ) then statement1else statement2endif
让我们实现上述语法以使用 if not in -
mysql> delimiter //mysql> create procedure if_not_indemo(in value int) -> begin -> if(value not in (10,20,30) ) then -> select "value not found"; -> else -> select "value found"; -> end if; -> end -> //query ok, 0 rows affected (0.25 sec)mysql> delimiter ;
现在使用 call 命令调用存储过程。
情况 1 - 当找到值时 -
mysql> call if_not_indemo(10);
输出+-------------+| value found |+-------------+| value found |+-------------+1 row in set (0.00 sec)query ok, 0 rows affected (0.01 sec)
情况 2 - 未找到值时 -
mysql> call if_not_indemo(100);
输出 +-----------------+ | value not found | +-----------------+ | value not found | +-----------------+1 row in set (0.05 sec)query ok, 0 rows affected (0.07 sec)
以上就是我们可以在 mysql 过程中使用“if not in”吗？的详细内容。