Multi Query PHP Question

Question

I wanted to execute multiple queries in one. Is there a way to condense a bunch of queries into one big string and then execute it? Thanks in advance.

I'm not sure this would make sense. What kind of result set would you get back if your queries look up all different columns in different tables? This would make sense for DML statements, you could just concatenate the query strings and execute, but not queries. Show use the queries in question and maybe we can help rebuild it? — FrustratedWithFormsDesigner
– FrustratedWithFormsDesigner, Commented Oct 4, 2010 at 15:52
Anthony, let's say there was a table full of meta data like Wordpress does it, and instead of executing 8-12 lines of separate sql queries for one table, I wanted to do it in 1 shot. — willbeeler
– willbeeler, Commented Oct 6, 2010 at 14:35

ITroubs · Accepted Answer · 2010-10-04 16:05:40Z

3

Just use mysqli

It is the successor to the mysql functions and also exists in either procedural an object oriented implementation.

It can do multiple querys per one session and even return all different sets after the multi query. for more information read:

multi_query()

answered Oct 4, 2010 at 16:05

ITroubs

11.2k4 gold badges30 silver badges25 bronze badges

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

Comments

Jon Black · Accepted Answer · 2010-10-04 15:58:45Z

0

yes it's called a stored procedure - use 'em !!

answered Oct 4, 2010 at 15:58

Jon Black

16.6k5 gold badges45 silver badges42 bronze badges

Collectives™ on Stack Overflow

Multi Query PHP Question

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related