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
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?
Reg
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 'Tab
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: 860.674.8
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
esday, August 22, 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 thos
L PROTECTED]
>>>Sent: Tuesday, August 22, 2006 2:22 PM
>>>To: mysql@lists.mysql.com
>>>Subject: Finding field in all tables
>>>
>>>Is there any way to find a column name (or, better yet, a
>>>partial column
>>>name) in all tables within a
Is there any way to find a column name (or, better yet, a partial column
name) in all tables within a data base?
I inherited a complex and totally undocumented data base, and need to find
out (for example) which tables have a column name like xxx_exported.
Regards,
Jerry Schwartz
Global Informa
