Scan all tables nfor some variables

[stonyheng]

hi all,

Is there a code where i can check from all the existing tables if a certain variables exist in it? I am currently working on a project but the tables are not linked properly, having a hard time trying to find out how many tables actually have the same variable as the key table.

Thanx

[jemajoign]

What do you mean when you say you want to find out "how many tables actually have the same variable as the key table?"

[tesuji]

Hi again,

you need to query the system tables (dictionary/catalogue) of MySql. Start with columns table.

krs,
tesu