get tables in mysql code example

Example 1: show tables mysql

SHOW TABLES;

Example 2: select tables from mysql database

SHOW TABLES from <databasename>;