Hi.
It cannot be done with a SQL command, except if the structure of all
involved tables is the same. In this case, have a look for MERGE
tables.
Else, you could create a temporary table and use
INSERT INTO temp SELECT ...
for all tables in question. Of course, you can simulate this in your
application, too.
Bye,
Benjamin.
On Sat, Sep 08, 2001 at 09:09:42PM -0500, [EMAIL PROTECTED] wrote:
> How do I select all of the tables in a database and use a whre clause like
> this??::
>
> SELECT * FROM alltables(substitute with command) WHERE User = 'username'
>
> I need this for my site (Code Cafe- Free source code) so that the user can
> see all the code he has uploaded. It is done in ASP, but all I need is the
> sql query string. Thanx
>
> - Deryck H
> - http://www.comp-u-exchange.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
