how to see the tables in a database in mysql code example Example 1: mysql show all tables show tables; Example 2: mysql command show tables SHOW TABLES;