declare 定义变量 set 为变量赋值 下面是一个例子: mysql> DELIMITER // mysql> CREATE PROCEDURE TestWhile() -> BEGIN -> DECLARE v_index INT; -> -> SET v_index = 0; -> -> WHILE v_index < 5 DO -> SET v_index = v_index + 1; -> SELECT v_index; -> END WHILE; -> -> END// Query OK, 0 rows affected (0.00 sec)
mysql declare和set有什么区别啊?
最新推荐文章于 2023-08-28 19:39:12 发布