Love it when that happens :)
Fastest way I can think of is dumping out the structure of the database
with mysqldump -d database.sql
and then searching the output to see where those columns appear
-Original Message-
From: Jerry Schwartz [mailto:[EMAIL PROTECTED]
Sent: Tuesday,
, 2006 2:41 PM
To: Jerry Schwartz; mysql@lists.mysql.com
Subject: RE: Finding field in all tables
Love it when that happens :)
Fastest way I can think of is dumping out the structure of the database
with mysqldump -d database.sql
and then searching the output to see where those columns appear
Is there any way to find a column name (or, better yet,
a partial column name) in all tables within a data base?
1. If the db is not in 5.0, mysqldump the DML to a file, run that file
in an instance of MySQL 5.x.
2. Query information_schema.
PB
-
Jerry Schwartz wrote:
Is there any way
I haven't ventured into MySQL 5.x, I have enough trouble working with this
house of cards I was handed. I'll try to remember this for the future,
though.
Thanks to all.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX:
Jerry
I haven't ventured into MySQL 5.x, I have enough trouble working
with this
house of cards I was handed. I'll try to remember this for the
future,
though.
All you need to do is install mysql 5 in any box, run the dump script,
then execute one query:
SELECT
LOWER(table_name) AS
Unfortunately, I have no experience running two versions of MySQL on the
same box, and we have no development environment. That contributes to my
timidity.
By the way, I thought I read that the list wouldn't accept HTML-coded
messages; but yours came through that way. Did I misread something?
Jerry Schwartz wrote:
Unfortunately, I have no experience running two versions of MySQL on the
same box, and we have no development environment. That contributes to my
timidity.
Just one 'puter? Yikes.
By the way, I thought I read that the list wouldn't accept HTML-coded
messages; but yours