get all tables from mysql database code example

Example 1: mysql show tables in database

show tables;

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';