how to see data of table in mysql code example

Example 1: mysql show data from table

mysql> SELECT * FROM [table name];

Example 2: how to check which table has data in mysql

mysql> SELECT table_name, table_rows
   ->FROM INFORMATION_SCHEMA.TABLES
   ->WHERE TABLE_SCHEMA = 'business';