Update in once all values Azure MySql

(0) Share

Report

Posted on by For3st

Hi All,

I will want my application to update the list of records in my database Azure SQL.

How should works:

After press the button on the application. The application supposed to search all values which are in the variable "Control_Number" and change in Azura Table "users.easn", column "Status". From "In Progress" to "Booked In"

I manage how to make one by one, but application will needed to do for 200 in once, which means that is taking a lot of time for the app to change every records one by one. For 200 changes is taking +20 sec.

Goal/Question: How I mantion before, I will want to update in once specific grupe of data that will take less time for the app to process. Maybe to just sending query to the SQL from the apps, that the database will make the change and the user will be able to work again with applicaiton