CREATE PROCEDURE update_order_categories()
BEGIN
DECLARE $orderId varchar(10);
DECLARE $categoryId INT;
DECLARE STOP INT DEFAULT 0;
#定义第一个游标
DECLARE ca_orderId CURSOR FOR SELECT id FROM `order` WHERE categories is null and date(created_time)>=DATE_SUB(date(now()),INTERVAL
mysql存储过程游标嵌套示例
最新推荐文章于 2022-08-17 15:20:49 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)