Re: Need Some PERL-MySQL help

[Gowtham <sgowtham@xxxxxxx>]

Jon, LUGgers:

I should have been a bit more elaborate about 
the problem.

The first query is done to a database on one
server. The results are stored in memory. The
second query is done to a database in another
server. The results are stored in memory.

Then, the two results are merged together.

Thanks,
g




On Wed, 25 Feb 2009, Jon DeVree wrote:

| On Wed, Feb 25, 2009 at 07:25:00AM -0600, Gowtham wrote:
| > How do I store result of MySQL query in memory in PERL?
| > I then need to merge it with result of another query.
| >
| 
| Unless you're doing something completely oddball that prevents this, I
| suggest letting your SQL server do the merge for you. 
| 
| http://dev.mysql.com/doc/refman/6.0/en/join.html
| 
| -- 
| Jon
| "You're talking about a group of people who are paid large sums of money for
| their ability to communicate with inanimate objects made of melted sand."
|         -NANOG
| 



--
Gowtham
http://sgowtham.net/