943,884 Members | Top Members by Rank

Web Development > Databases > MySQL > Scan all tables nfor some variables
Ad:
  • MySQL Discussion Thread
  • Unsolved
  • Views: 880
  • MySQL RSS
Permalink
May 21st, 2008
0

Scan all tables nfor some variables

Expand Post »
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
Reputation Points: 10
Solved Threads: 0
Newbie Poster
stonyheng is offline Offline
4 posts
since May 2008
Permalink
May 21st, 2008
0

Re: Scan all tables nfor some variables

What do you mean when you say you want to find out "how many tables actually have the same variable as the key table?"
Reputation Points: 10
Solved Threads: 0
Newbie Poster
jemajoign is offline Offline
10 posts
since May 2008
Permalink
May 21st, 2008
0

Re: Scan all tables nfor some variables

Hi again,

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

krs,
tesu
Reputation Points: 158
Solved Threads: 98
Master Poster
tesuji is offline Offline
720 posts
since Apr 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MySQL Forum Timeline: How to stop iterating through a table?
Next Thread in MySQL Forum Timeline: SQL





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC