On Fri, 03 Aug 2007 06:01:46 -0000, petersprc <petersprc@gmail.com>
top posted like a moron and wrote:

>You can reference the table using the db name: select count(*) from
>D.X.
>

That directly selects on the database which looks at engine=memory to
know how to work and yes, it will work, but I'm not sure that's what
Joe means. Joe?



>On Aug 2, 10:52 am, JoeT <trub...@yahoo.com> wrote:
>> Hi...
>>
>> Maybe this is not possible in MySQL, but what I want to do is as
>> follows: in database D, create a table X with engine=memory, and,
>> assuming it's loaded at server startup, if another user is using
>> database W for example, they could do a select against X in database
>> D.
>>
>> Can do this in other databases, but couldn't find a reference in
>> MySQL.
>>
>> Can it be done?
>>
>> TIA,
>> Joe
>
--
gburnore at DataBasix dot Com
---------------------------------------------------------------------------
How you look depends on where you go.
---------------------------------------------------------------------------
Gary L. Burnore | ÝÛ³ºÝ³Þ³ºÝ³³Ýۺݳ޳ºÝ³Ý³Þ³ºÝ³ÝÝÛ³
| ÝÛ³ºÝ³Þ³ºÝ³³Ýۺݳ޳ºÝ³Ý³Þ³ºÝ³ÝÝÛ³
Official .sig, Accept no substitutes. | ÝÛ³ºÝ³Þ³ºÝ³³Ýۺݳ޳ºÝ³Ý³Þ³ºÝ³ÝÝÛ³
| ÝÛ 0 1 7 2 3 / Ý³Þ 3 7 4 9 3 0 Û³
Black Helicopter Repair Services, Ltd.| Official Proof of Purchase
================================================== =========================