Help needed to write MYSQL query in PHPMYADMIN

Asked By vasupoojary 0 points N/A Posted 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)

 

 

Thank you

 

 

• Status: Open
• Question Views: 886
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Parsh Auguston 0 points N/A #160725

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.

1. Define each instance and entity separately.
2. Every noun/entity gets to have a separate table with its specifications as separate attributes in the table.
3. Define the relationship efficiently as the whole DB is based on this structure.
4. Define the Primary keys properly and use foreign keys where necessary.
5. Properly orient the data so that there is no ambiguity in it

About Parsh Auguston

Questions
2

Answers
152

Best Answers
12

• Vote Up 0 Vote Down

• Posted on - 08/04/2012
• Question Category: MySQL Server