Mysql Tables
Each database will contain one or more tables once an application starts storing data in it. The application should usually be what creates tables and modifies them.
List tables
Use the “show tables” command to list the tables in a database:
SHOW TABLES FROM databasename;
Count the rows in a table
A simple query to count the number of rows (entries) in a table would look like:
SELECT COUNT(*) FROM databasename.tablename;
Show all data in a table
To list absolutely every entry in a table, run:
SELECT * FROM databasename.tablename;
Note that this will usually be a huge result. You can list just the fields you want to view from each entry by listing them in place of “*” above, separating them with commas.