Hi.
On Sun, Sep 09, 2001 at 04:44:24PM -0500, [EMAIL PROTECTED] wrote:
> Thanx ben. But I have found a way to do it :
>
> SELECT * FROM Asp, C, Cpp, Java, Javascript, etc... Where
You know, that this is not really the same? You (should) get each code
of each table paired with each code fr
-
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 allofth
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
a
Deryck,
Since you already got a reply that it can't be done, here's a suggestion how it
*could* be done (jus a general approach - since you mention usnig ASP):
- use an SQL command to gather all the table names in the database
- store the names in a list or array (ASP)
- use ASP to loop over th
At 9:09 PM -0500 9/8/01, Deryck Henson 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'
You can't.
>
>I need this for my site (Code Cafe- Free source code) so that the user can
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