更新时间:2023-01-19 20:18:42
不幸的是,您不能在存储程序之外使用LOOP:存储过程,存储函数和触发器.
Unfortunately you can't use LOOP outside of a stored program: stored procedures, stored functions, and triggers.
您确实有一些选择:
否则,如果您仍然不想创建存储过程,那么***的选择是用shell,python等编写一个小的脚本来进行循环.
Otherwise, if you still don't want to create a stored procedure, your best bet is to write a small script in shell, python, etc to do your looping.
祝你好运!