Help needed to write MYSQL query in PHPMYADMIN

Asked By 0 points N/A Posted on -
qa-featured

 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

 

 

SHARE
Answered By 0 points N/A #160725

Help needed to write MYSQL query in PHPMYADMIN

qa-featured

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

Related Questions