MySQL中逗号分隔的变量 [英] Comma separated variable in MySQL

问题描述

我想在MySQL中创建一个存储过程，输入参数之一将是一个逗号分隔的整数列表.如何遍历每个整数并对其运行更新语句?

I want to create a stored procedure in MySQL and one of the input parameters will need to be a comma separated list of integers. How do I loop through each integer and run an update statement on it?

我已经对其进行了谷歌搜索，但似乎找不到任何适用于MySQL的东西.

I've googled it but can't seem to find anything that will work for MySQL.

推荐答案

我明白了...

DECLARE i INT DEFAULT 0;
DECLARE curId VARCHAR(100);
WHILE SPLIT_STR(in_IdCommaDelimited, ',', i) != '' DO

    SET curId = SPLIT_STR(in_IdCommaDelimited, ',', i);

    UPDATE MyTable SET OrderNumber = i WHERE Id = curId;

    SET i = i + 1;  

END WHILE;

这篇关于MySQL中逗号分隔的变量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！