FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


MYSQL: How check what is the related tables





macky
Hi there guys.. i just want to know if there is a syntax in mysql or in php that would shows what is the

related tables to an specific tables without knowing what is the related tables.


SUCH AS MAYBE like this-> SELECT * RELATED TABLES FROM TB1
jmraker
I don't think so, but you can make a custom "database connections" table and then you'd have a way to define that "field b" in "table b" and "field c" in "table c" are both foreign keys to "field a" in "table a". (2 database records) and so on.
badai
1. use InnoDB and use foreign key.
2. develop properly by having ERD. use MySQL Workbench.
macky
I see.. I also thought that thing. Well really for me to think that idea is a bit impossible.

But why not? hhmmmm... Maybe in the near future we can achieve this feature.

The logic will be there are new key can shows in what tables its related without knowing what tables it is related.

I have 109 tables in one database in the office. The database has no Database Schema or Documentation and my job is to determined them. hahahha.. it's really hard!
Related topics
codewalkers.com
[man]Servidor Web Personal (Tutorial)
My site =)
A very good PHP MySQL Tutorial
question about something really big..
Connecting to 2 different Mysql database and tables?
mysql insert into multiple tables at once?
SQL.....Where to start?
indexes in MySQL
Creating databases
Logic MySql
MySQL => Select tables by prefix
Tables
need help
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.