how to show tables code example
Example 1: mysql show tables in database
show tables;
Example 2: select tables from mysql database
SHOW TABLES from <databasename>;
Example 3: show tables mysql
Press CTRL+C to copy SHOW [EXTENDED] [FULL] TABLES
[{FROM | IN} db_name]
[LIKE 'pattern' | WHERE expr]