list a table mysqç code example

Example 1: mysql show tables in database

show tables;

Example 2: select tables from mysql database

SHOW TABLES from <databasename>;