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