|
Here is the test suite that produces 3 affected rows with multi-UPDATE statement. Under the hood CS updates cs1 three times.
MariaDB [test]> select * from cs1
|
-> ;
|
+------+------+
|
| i | t |
|
+------+------+
|
| 1 | sa |
|
| 7 | NULL |
|
| 5 | NULL |
|
+------+------+
|
3 rows in set (0.04 sec)
|
|
MariaDB [test]> select * from i1;
|
+------+------+
|
| i | t |
|
+------+------+
|
| 1 | a |
|
| 2 | b |
|
| 3 | c |
|
+------+------+
|
3 rows in set (0.01 sec)
|
|
MariaDB [test]> update cs1 join i1 on i1.i=cs1.i set cs1.t = 'sa';
|
Query OK, 3 rows affected (16.40 sec)
|
|