How do a I list all tables containing a given column name? I'm using Mysql version 4.1.13-nt-log. I know versions less than 5 dont have an information_scheme DB.
A:
also found this... looks promising, but I'm not sure how ambitious you are
try this:
mysqldump -u root -p –all-databases –single-transaction > all.sql
and then do the searching the old-school way in a text editor with find
also found this... looks promising, but I'm not sure how ambitious you are
http://mike.kruckenberg.com/presentations/Creating_INFORMATION_SCHEMA.pdf
CheeseConQueso
2010-03-07 15:45:53