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