在Naticat中使用函数对数据库插入测试数据

BEGIN
    #Routine body goes here...
    DECLARE a INT DEFAULT 90;
    DECLARE b INT DEFAULT 1;
    WHILE b<=a DO
    INSERT INTO productstock(`product_id`) VALUES (`b`);
    SET b = b+1;
    END WHILE;
    RETURN b;
END

效果图：

说明，id默认从1开始，然后自增，stock默认1000；

更新语句：

BEGIN
    #Routine body goes here...
    DECLARE a INT DEFAULT 90;
    DECLARE b INT DEFAULT 1;
    WHILE b<=a DO
    UPDATE product SET product_review_count = 
  (SELECT COUNT(1) as c FROM review as r WHERE r.review_product_id in (`b`)) 
  WHERE product_id = `b`;
    SET b = b+1;
    END WHILE;
    RETURN b;
END

注意：自定义函数体不可使用select函数！