MariaDB Running Bulk Mysql Queries Effeciently.

Greetings everyone, i hope everyone is safe and doing alright in this hard time.

---

I wanted to know whats the faster and efficient way of running thousands MySQL Update quries.

I am doing it directly, which is taking time and creates MySQL load.

 

Here is what i am using, since i have innoDB tables

Code:

#!/bin/sh
echo "This program will update blahblahblah..."
echo "After starting this program, enter your database password for root"
DATABASENAME=databasenamehere

mysql -u root -p <<-ENDMARKER

 use ${DATABASENAME};
 START TRANSACTION;
UPDATE
UPDATE
 COMMIT;

ENDMARKER

found it on Digitalocean.