MySQL Cursor Loop不会更新

如果我理解正确的话，你就是

CROSS JOIN

INSERT INTO bullets (product_pre, bullet_text) SELECt m.product_pre, b.bullet_text   FROM bullets b CROSS JOIN master m WHERe b.product_pre = 10001   AND m.product_group = 3   AND m.product_pre <> 10001;

这是 SQLFiddle 演示。

现在，如果您转到

CREATE PROCEDURE copy_bullets_test (IN product_pre_from INT, IN product_group_to INT)INSERT INTO bullets (product_pre, bullet_text) SELECt m.product_pre, b.bullet_text   FROM bullets b CROSS JOIN master m WHERe b.product_pre = product_pre_from   AND m.product_group = product_group_to   AND m.product_pre <> product_pre_from;

并使用它

CALL copy_bullets_test(10001, 3);

这是这种情况的 SQLFiddle 演示。