I want to move my data from mysql A to mysql B, when I get to 20W rows
the error messages
Hi @liushengyi,
Do you mean 20M records? Are you creating insert string in function in one step? Probably this is the problem. String length is too large.
Limiting results by offset in first mysql node can do the job. And after, you need to generate insert string for the limited rows, and go ahead for next rows.
Hope this helps.
Thanks a lot @Miquel_Colomer!
Yes totally agree. A large amount of data is very likely the problem here. In this case it would make sense to split it into multiple workflow runs.
@Miquel_Colomer @jan thanks for reply . I chose to split the workflow and executed successfully.
Glad to hear that you found a solution. Have fun!