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
[man]Servidor Web Personal (Tutorial)
question about something really big..
Connecting to 2 different Mysql database and tables?
indexes in MySQL
Logic MySql
MySQL => Select tables by prefix
codewalkers.com
My site =)
SQL.....Where to start?
Creating databases
Tables
need help
A very good PHP MySQL Tutorial
mysql insert into multiple tables at once?
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.