How can I insert multiple rows to MySQL using web API in a flutter mobile application

31 Views Asked by At

I have been developing a mobile application in Flutter at Visual Studio Code environment.

For the backend layer I have developed a webapi in Python (in PyCharm env.)

For the database, I use MySQL (version 8.0.34).

I am currently able to communicate with the database properly for both get, insert, update or delete actions. But now I need to insert multiple rows (I have dynamic count rows, not a certain number of rows) into the database in a single action via the webapi. I don't want to send insert commands in a for loop or something like that.

I have searched over google but could not find an exact solution. Just few solutions didn't work.

I have tried to send multiple rows in a for loop but it made slow the application down. I need to deliver all the data to the mySql. I have also found some solutions for a certain number of rows, that adding extra parameters. But in my project, the number of insert rows is not fixed.

0

There are 0 best solutions below