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
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.
1. use InnoDB and use foreign key.
2. develop properly by having ERD. use MySQL Workbench.
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!