Thanx ben. But I have found a way to do it :
SELECT * FROM Asp, C, Cpp, Java, Javascript, etc... Where ....
If you know asp, write to me in private, I have something that (if you do
know asp) you might be able to help me with.
- Deryck H
- http://www.comp-u-exchange.com
----- Original Message -----
From: "Benjamin Pflugmann" <[EMAIL PROTECTED]>
To: "Deryck Henson" <[EMAIL PROTECTED]>
Cc: "MySQL" <[EMAIL PROTECTED]>; "Webmaster"
<[EMAIL PROTECTED]>
Sent: Sunday, September 09, 2001 4:30 PM
Subject: Re: SELECT * FROM allofthetables
> 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
