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
– gnur, Commented Apr 7, 2011 at 12:18
@Lawrence and @gnur As the question titled He is asking for update query — Shakti Singh
– Shakti Singh, Commented Apr 7, 2011 at 12:33

Oliver M Grech · Accepted Answer · 2011-04-07 12:17:37Z

4

you will have to use mysqli instead of mysql.

Please refer to the following

answered Apr 7, 2011 at 12:17

Oliver M Grech

3,1991 gold badge25 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Shakti Singh · Accepted Answer · 2011-04-07 12:17:52Z

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 7, 2011 at 12:17

Shakti Singh

86.7k21 gold badges142 silver badges156 bronze badges