How to run multiple Update Queries in single statement in PHP and mySQL

Question

I want to run the multiple queries in single statement how to do this.

What kind of multiple queries? Multiple inserts in the same table: possible. Combination of different type of queries: not possible within php. — gnur, Apr 07 '11 at 12:18
@Lawrence and @gnur As the question titled He is asking for `update` query — Shakti Singh, Apr 07 '11 at 12:33
Possible duplicate of [Multiple Updates in MySQL](http://stackoverflow.com/questions/3432/multiple-updates-in-mysql) — Kristijan Iliev, Feb 03 '16 at 08:49

score 4 · Accepted Answer · answered Apr 07 '11 at 12:17

4

you will have to use mysqli instead of mysql.

Please refer to the following

answered Apr 07 '11 at 12:17

Oliver M Grech

score 4 · Answer 2 · answered Apr 07 '11 at 12:17

4

You can run multiple queries using mysqli::multi_query()

as the mysql_ function family does not provide feature to execute multiple queries in once.

answered Apr 07 '11 at 12:17

Shakti Singh

2 Answers2