MySQL loop through variable

Asked Sep 25 '19 at 12:53

Active Sep 25 '19 at 12:55

Viewed 93 times

I have a variable @ids = "894,891,896,899..."

What I like to do is the following

loop @id: @ids
     INSERT INTO `testcases_types` (`testcase_id`, `type_id`) VALUES (@id, '57');
     INSERT INTO `testcases_types` (`testcase_id`, `type_id`) VALUES (@id, '58');
     INSERT INTO `testcases_types` (`testcase_id`, `type_id`) VALUES (@id, '59');
     INSERT INTO `testcases_types` (`testcase_id`, `type_id`) VALUES (@id, '60');
end loop

So I tried a lot now , but I cannot find out the right syntax. I do not want to write a procedure. I just want to execute it once .

edited Sep 25 '19 at 12:55

Juan Carlos Oropeza

47,252
12
78
118

asked Sep 25 '19 at 12:53

Flo19

Is `@id` a string? where you get the `type_id` from? or is autonumeric. Show us `create table` for `testcases_types` – Juan Carlos Oropeza Sep 25 '19 at 12:56
Possible duplicate of [SQL split values to multiple rows](https://stackoverflow.com/questions/17942508/sql-split-values-to-multiple-rows) – Juan Carlos Oropeza Sep 25 '19 at 12:57
@ids is a string . Yes. As you can see by the quotes. – Flo19 Sep 25 '19 at 13:11
' I do not want to write a procedure' - you cannot use loops outwith stored programs (procedures,function,triggers,events) – P.Salmon Sep 25 '19 at 14:09
What about the `type_id` ?? – Juan Carlos Oropeza Sep 25 '19 at 14:12

MySQL loop through variable

0 Answers0