Web lists-archives.com

Re: Merging multiple SQL requests




----- Original Message -----
> From: "Jay Ess" <lists@xxxxxxxxxxxxxx>
> Subject: Re: Merging multiple SQL requests

> "UNION is used to combine the result from multiple SELECT statements into a
> single result set."

Yes, but only if your queries return the same number of fields; and you get a single resultset out of it.

I was under the impression that OP wanted to simply batch multiple unrelated small resultsets in a single network packet.


-- 
Unhappiness is discouraged and will be corrected with kitten pictures.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql