[AccessD] Missing SubQueries in MySQL

Gustav Brock gustav at cactus.dk
Sat Feb 8 05:13:01 CST 2003


Hi Arthur

> 1. Que cancelled the book. Peter and I are posting chapters gradually to our
> website. See http://www.artfulsoftware.com

Oh, that's a pitty; it looked promising.

On those chapters: That's very kind of you.
But none is published yet, right? (Can't find any).

> 2. Download the current gamma, whose support for these constructs is...
> well, on the way :-)

> 3. Alternatively, use Access as the FE, MyODBC as the bridge and MySQL as
> the BE, wherever it resides and atop whatever platform. Save named queries
> in the standard Access way, building atomic then molecular queries.

That is, of course, a straightforward possibility.

/gustav


> Just curious: Are you making progress with your book on MySQL?

> Do you have some clever suggestions on how to circumvent the missing
> subqueries in MySQL?


>> Lest we be seen to agree in public, JC, let me object that MySQL can work
>> on
>> big iron, too. And if you have 120M rows in a table and need to select the
>> top 10 according to some column(s), nothing can do it quicker than MySQL.
>> It lacks a lot, but speed isn't on the list.
>> So the big iron folks unafraid of Linux and having 120M rows in various
>> tables (c.f. Yahoo) use MySQL. The banks and the other suits trust Larry.
>> All the same, a MySQL install is a little like an Austin Healey 3000. Be
>> prepared to tinker, and to have to know stuff that mere mortals cannot
>> fathom :-) OTOH I notice that the Linux guys get more money per hour than
>> us Windoze guys.




More information about the AccessD mailing list