G
G
ganbatte2020-06-02 12:52:11
MySQL
ganbatte, 2020-06-02 12:52:11

In a mysql procedure, is it possible to create a LOOP on data like these [4,5,6,7,4,6,8]?

For example, in a mysql procedure, is it possible to do something like this ?

$array = [4,5,6,7,4,6,8];
for ($array as $data) {
updateToTable1($data);
updateToTable2($data);
updateToTable3($data);
}

In short, you need to run an array of data in one scenario.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
L
Lazy @BojackHorseman MySQL, 2020-06-02
@ganbatte

13.6.6 Cursors

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question