Here it is in perl/DBI using hashes of arrays:
my $database =
DBI->connect("DBI:mysql:database=$DATABASENAME;host=$HOSTNAME
ST",$MYSQLUSER,$MYSQLPASS,{RaiseError=>0,PrintError=>0});
my $tablea = $database->prepare("SHOW TABLES FROM DATABASENAME");
$tablea->execute();
my @active_table
On Fri, 9 Mar 2001, Cal Evans wrote:
> You can't. SQL wasn't designed to do that.
>
> Do all your tables have the same structure?
For a quick and dirty solution: what about using a shell script getting
table names from the data directory and launching the mysql client for
every table?
Thomas
ECTED]]
Sent: Friday, March 09, 2001 6:25 AM
To: Cal Evans; [EMAIL PROTECTED]
Subject: Re: searching ALL tables
no, they do not have the same structure,
someone said something about creating a loop using php
since idealy this will end up being a web published database
this sounds good to me, just
ROTECTED]>
Sent: Friday, March 09, 2001 10:52 PM
Subject: RE: searching ALL tables
You can't. SQL wasn't designed to do that.
Do all your tables have the same structure?
Cal
http://www.calevans.com
-Original Message-
From: Adam Crawford [mailto:[EMAIL PROTECTED]]
Sent:
You can't. SQL wasn't designed to do that.
Do all your tables have the same structure?
Cal
http://www.calevans.com
-Original Message-
From: Adam Crawford [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 09, 2001 1:53 AM
To: [EMAIL PROTECTED]
Subject: searching ALL tables
Hi all,
I just want to know how to search all tables
I can work out how to search one table, or a few of them at a time
but since we have 1000+ tables, I figure there must be an easyer way
I have tried using % & * instead of the table name, but with no luck
Hope someone can help
Thank you in adva
