Thanks for your answer, I´ve created a TEMPORARY table and it seems to work well for my purpose, the only doubt I still have is, if the table gets automatically deleted when the user closes the connection, or should I do something within my script to avoid a stack overflow? if there are too many simultaneous connections which create several temporary tables is it posible to knock down the server?
thanks in advance ----- Original Message ----- From: "David Yahoo" <[EMAIL PROTECTED]> To: "Walter D. Funk" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, January 04, 2002 3:45 PM Subject: Re: UNION > You have to search for "create temporary" table then make > severals > insert into this_table as select .... > > Note that the temporary table are thread local I think so only the current > connexion can see it. > > > > > > HI, > > > > I found a very usefull function in Mysql (to combine the result of many > > SELECTS in one result set ), which is UNION > > SELECT .... > > UNION [ALL] > > SELECT .... > > [UNION > > SELECT ...] > > > > the problem is, that it was implemented in version 4.0 and above; > > anyone can tell me if there is a way to re-phrase the same query but > > for an older engine, like 3.23.33 > > > > best regards > > Walter D. Funk > > > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php