[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: searching ALL tables

To: Cal Evans <cal@xxxxxxxxxxxx>
Subject: RE: searching ALL tables
From: Thomas Spahni <tsp@xxxxxxxxx>
Date: Fri, 9 Mar 2001 15:09:19 +0100 (CET)
Cc: Adam Crawford <ca@xxxxxxxxxxxxxxxxxxxx>, mysql@xxxxxxxxxxxxxxx
In-reply-to: <NABBLCCEONHNHBGBBPHPEEDIAJAB.cal@xxxxxxxxxxxx>
List-help: <mailto:mysql-help@lists.mysql.com>
List-id: <mysql.mysql.com>
List-post: <mailto:mysql@lists.mysql.com>
List-subscribe: <mailto:mysql-subscribe@lists.mysql.com>
List-unsubscribe: <mailto:mysql-unsubscribe-treed=ultraviolet.org@lists.mysql.com>
Mailing-list: contact mysql-help@xxxxxxxxxxxxxxx; run by ezmlm (http://www.ezmlm.org)

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

---------------------------------------------------------------------
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 <mysql-thread67778@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

References:
- RE: searching ALL tables
  - From: Cal Evans

Prev by Date: Antwort: decimal(8,2) rounding bug or still "to be expected" behaviour?
Next by Date: ODBC
Previous by thread: RE: searching ALL tables
Next by thread: Re: searching ALL tables
Index(es):
- Date
- Thread

This mailing list archive is a service of Copilot Consulting.