![](https://seccdn.libravatar.org/avatar/7891b1b1a5767f4b9ac1cc0723cebdac.jpg?s=120&d=mm&r=g)
Carlos E. R. wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
On 19/12/2019 15.08, Per Jessen wrote:
Per Jessen wrote:
I would need to produce a list of statements like this:
update table set column=function(column) order by column limit 100000; update table set column=function(column) order by column limit 100000; update table set column=function(column) order by column limit 100000; update table set column=function(column) order by column limit 100000; update table set column=function(column) order by column limit 100000;
until all rows are updated. If only I could write a loop in sql.
An expect script?
No, it would have to be SQL statements only, as null-terminated C-strings. The code is C++. Anyway, the problem has miraculously solved itself. No logical explanation, but I patched the main library to use MYSQL_OPT_READ_TIMEOUT=60. I wanted to see the steup program stop after 3x60 seconds to make sure that parameter was in fact in use. Well it didn't. Instead it finished the database upgrade and the system is now working. I cannot explain it. -- Per Jessen, Zürich (6.9°C) http://www.dns24.ch/ - free dynamic DNS, made in Switzerland. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org