Hi,
Is it possible to create a temporary table in mySQL using columns from tables in
two databases? Basically I want to split a table between two databases and if some
logic is satisfied I want to merge(the right word?) the
two tables into one in one of these databases. What's the best way
]
Sent: Monday, March 15, 2004 3:31 PM
Subject: Temporary tables in mySQL
Hi,
Is it possible to create a temporary table in mySQL using columns
from tables in two databases? Basically I want to split a table between two
databases and if some logic is satisfied I want to merge(the right word
A understand that a problem with temporary tables is that you can't
do a self-join in MySQL 3.xx using temporary tables. I have a situation
that requires exactly this (the alternative is not algorithm-effective).
I wonder if the following is a practical solution: to create a copy of the