show tables in a database mysql code example Example 1: mysql show all tables show tables; Example 2: select tables from mysql database SHOW TABLES from <databasename>;