Home > Solution Categories > Database > MySQL Server > Help needed to write MYSQL query in PHPMYADMIN
Question
No of visitors who read this post: 243
Category: MySQL Server
Type: Question
Author: Vasupoojary
No votes yet

 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

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

#

Submitted by Parsh Auguston on Sat, 2012-08-04 18:51. Comment Id: 74497

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
Previous Previous Page
111 of 244
Next Page Next