N/APosted on - 06/11/2012
Please help me to write the query in MYSQL. I am using PHPMYADMIN
1)List of the tables in a database and where are they located? (user created tables only not system tables)
2) How many rows of data in each table in Database? (user created tables only not system tables)
3) List of all the fields in each table in database? (user created tables only not system tables)
Help needed to write MYSQL query in PHPMYADMIN
No one can actually tell you the things that you can do while writing the query as everyone will predict it according to its own way. So it is better if you write it in your own way. However there are few things that you can take care while writing it.
Define each instance and entity separately.
Every noun/entity gets to have a separate table with its specifications as separate attributes in the table.
Define the relationship efficiently as the whole DB is based on this structure.
Define the Primary keys properly and use foreign keys where necessary.
Properly orient the data so that there is no ambiguity in it