select all tables in database mysql code example

Example 1: mysql show all tables

show tables;

Example 2: select tables from mysql database

SHOW TABLES from <databasename>;