how to get all tables from mysql code example Example 1: mysql command show tables SHOW TABLES; Example 2: mysql command show tables mysql -u user -p