I am currently creating a workflow where I am to read data from one MySQL database and then insert it into another MySQL database. I have reused a couple of things from this workflow https://n8n.io/workflows/159
The issue I am facing is that the input DB is rather big and I, therefore, can’t load all the data at once as the JSON file becomes too big.
What I, therefore, need to do is to have a where clause that looks something like this:
WHERE id BETWEEN [variable_number] AND [variable_number2]
[variable_number] would then be 1, to begin with and change to the last id from the previous input and the [variable_number2] would be [variable_number] *1000 for example.
Does anyone know how I could accomplish this? I am not that familiar with js to some parts of the function nodes that are troublesome for me.