Scan all tables nfor some variables

Please support our MySQL advertiser: 50% off 6 Months Dedicated Server Hosting from 1&1!
Reply

•
•
Join Date: May 2008
Posts: 4
Reputation: stonyheng is an unknown quantity at this point 
Solved Threads: 0
stonyheng stonyheng is offline Offline
Newbie Poster

Scan all tables nfor some variables

 
0
  #1
May 20th, 2008
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
Reply With Quote Quick reply to this message  
•
•
Join Date: May 2008
Posts: 10
Reputation: jemajoign is an unknown quantity at this point 
Solved Threads: 0
jemajoign jemajoign is offline Offline
Newbie Poster

Re: Scan all tables nfor some variables

 
0
  #2
May 21st, 2008
What do you mean when you say you want to find out "how many tables actually have the same variable as the key table?"
Reply With Quote Quick reply to this message  
•
•
Join Date: Apr 2008
Posts: 296
Reputation: tesuji is on a distinguished road 
Solved Threads: 42
tesuji tesuji is offline Offline
Posting Whiz in Training

Re: Scan all tables nfor some variables

 
0
  #3
May 21st, 2008
Hi again,

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

krs,
tesu
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Other Threads in the MySQL Forum


Views: 807 | Replies: 2
Thread Tools Search this Thread



Tag cloud for MySQL
"use" .db 1 ajax alphabet amazon aws camparingtocolumns cascade cast code convert count count(col) data database delete design distinct ec2 eliminate enter error form generator html images innerjoins insert join keyword keywords matchingcolumns multiple multipletables mysql mysqldatetimeordermax() mysqlindex mysqlinternalqueries mysqlquery mysqlsearch noob number open operand oracle order parse pdf php print query recursive relationaldatabases relationship relationships remove reorderingcolumns resultset retrieve script search select simpledb sort sql statement string syntax table tree type-conversion update values welsh
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2010 DaniWeb® LLC