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 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 Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341
-- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.405 / Virus Database: 268.11.5/425 - Release Date: 8/22/2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]