Hello,
You might find the following challenging -or- you might now the answer :-)
Table Q
Subtable, field, val, ID
A 1 a42
A 2 b42
B 1 a78
B 2 t78
B 3 o78
C 1 u23
Table R
Subtableid, field, val
Hi,
It's true that MyISAM keeps two files descriptors open per open table
but this is MyISAM specific. An open table in MySQL isn't a one to one
mapping to file descriptors, it's simply a c++ object. It's up to the
storage engine how it manages file descriptors. Engines can use worker
threads with
On Fri, Jun 6, 2008 at 9:25 PM, TUT - LightSpeed <[EMAIL PROTECTED]> wrote:
>
> Actually they are 2 connection to 2 different databases on 2 different
> hosts.
> I wanted rquery results from db1 to be in a temporary table to be used in
> db2.
> I can go around it with some php code to create the t
