update multiple rows with multiple columns using loop

hi mate,

i have this query statement

UPDATE kai
SET `0522` = CASE WHEN `0522` IS NULL OR '0' THEN '' ELSE '1' END,
`0529` = CASE WHEN `0529` IS NULL OR '0' THEN '' ELSE '1' END,
`0605` = CASE WHEN `0605` IS NULL OR '0' THEN '' ELSE '1' END,
`0610` = CASE WHEN `0610` IS NULL OR '0' THEN '' ELSE '1' END,
`0610b` = CASE WHEN `0610b` IS NULL OR '0' THEN '' ELSE '1' END,
`0612` = CASE WHEN `0612` IS NULL OR '0' THEN '' ELSE '1' END,
`0619` = CASE WHEN `0619` IS NULL OR '0' THEN '' ELSE '1' END,
`0626` = CASE WHEN `0626` IS NULL OR '0' THEN '' ELSE '1' END,
`0703` = CASE WHEN `0703` IS NULL OR '0' THEN '' ELSE '1' END,
`0710` = CASE WHEN `0710` IS NULL OR '0' THEN '' ELSE '1' END,
`0717` = CASE WHEN `0717` IS NULL OR '0' THEN '' ELSE '1' END,
`0724` = CASE WHEN `0724` IS NULL OR '0' THEN '' ELSE '1' END,
`0731` = CASE WHEN `0731` IS NULL OR '0' THEN '' ELSE '1' END,
`0807` = CASE WHEN `0807` IS NULL OR '0' THEN '' ELSE '1' END,
`0808` = CASE WHEN `0808` IS NULL OR '0' THEN '' ELSE '1' END,
`0814` = CASE WHEN `0814` IS NULL OR '0' THEN '' ELSE '1' END,
`0821` = CASE WHEN `0821` IS NULL OR '0' THEN '' ELSE '1' END,
`0828` = CASE WHEN `0828` IS NULL OR '0' THEN '' ELSE '1' END,
`0902` = CASE WHEN `0902` IS NULL OR '0' THEN '' ELSE '1' END,
`0904` = CASE WHEN `0904` IS NULL OR '0' THEN '' ELSE '1' END,
`0911` = CASE WHEN `0911` IS NULL OR '0' THEN '' ELSE '1' END,
`0918` = CASE WHEN `0918` IS NULL OR '0' THEN '' ELSE '1' END,
`0925` = CASE WHEN `0925` IS NULL OR '0' THEN '' ELSE '1' END,
`1002` = CASE WHEN `1002` IS NULL OR '0' THEN '' ELSE '1' END,
`1009` = CASE WHEN `1009` IS NULL OR '0' THEN '' ELSE '1' END,
`1016` = CASE WHEN `1016` IS NULL OR '0' THEN '' ELSE '1' END,
`1023` = CASE WHEN `1023` IS NULL OR '0' THEN '' ELSE '1' END,
`1030` = CASE WHEN `1030` IS NULL OR '0' THEN '' ELSE '1' END,
`1106` = CASE WHEN `1106` IS NULL OR '0' THEN '' ELSE '1' END,
`1120` = CASE WHEN `1120` IS NULL OR '0' THEN '' ELSE '1' END,
`1120b` = CASE WHEN `1120b` IS NULL OR '0' THEN '' ELSE '1' END,
`1127` = CASE WHEN `1127` IS NULL OR '0' THEN '' ELSE '1' END,
`1130` = CASE WHEN `1130` IS NULL OR '0' THEN '' ELSE '1' END,
`1130b` = CASE WHEN `1130b` IS NULL OR '0' THEN '' ELSE '1' END,
`1204` = CASE WHEN `1204` IS NULL OR '0' THEN '' ELSE '1' END,
`1211` = CASE WHEN `1211` IS NULL OR '0' THEN '' ELSE '1' END,
`1218` = CASE WHEN `1218` IS NULL OR '0' THEN '' ELSE '1' END,
`1218b` = CASE WHEN `1218b` IS NULL OR '0' THEN '' ELSE '1' END,
`1218c` = CASE WHEN `1218c` IS NULL OR '0' THEN '' ELSE '1' END,
`1218d` = CASE WHEN `1218d` IS NULL OR '0' THEN '' ELSE '1' END,
`1219` = CASE WHEN `1219` IS NULL OR '0' THEN '' ELSE '1' END,
`1219b` = CASE WHEN `1219b` IS NULL OR '0' THEN '' ELSE '1' END,
`1219c` = CASE WHEN `1219c` IS NULL OR '0' THEN '' ELSE '1' END,
`1219d` = CASE WHEN `1219d` IS NULL OR '0' THEN '' ELSE '1' END,
`1219e` = CASE WHEN `1219e` IS NULL OR '0' THEN '' ELSE '1' END
WHERE empno='0005312004';

this was just one of the 5000 rows i need to update.

How can i use loop on this without getting server gone away error.

im trying to update 5000 rows... so basically im using a large loop here.

is there any better way in order to avoid server issue?

Any help would be appreciated.

Thank you

 

Is this a one time update? If so, the easiest way to do this is with ETL Software.
https://en.wikipedia.org/wiki/Extract,_transform,_load

 

what is the language and extesion
PHP , MySQLi & PDO i can make it and give

 

Yes, im using
PHP , MySQLi & PDO

 

Your using Mysqli AND PDO in the same script? You don't use both. Use PDO and be done with it.

 

PHP and Mysqli

 

You still didn't answer if this is a one time update you need to do. Where is the data coming from in the first place?

 

this is a one time update, and data comes from excel file.,

 

Did you look at ETL software as suggested? This is a good situation for it. If you are able to provide the file I can guide you.