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
Jump to PostHi again,
you need to query the system tables (dictionary/catalogue) of MySql. Start with columns table.
krs,
tesu
What do you mean when you say you want to find out "how many tables actually have the same variable as the key table?"
Hi again,
you need to query the system tables (dictionary/catalogue) of MySql. Start with columns table.
krs,
tesu
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.