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