get list of tables in mysql code example Example 1: mysql show tables in database show tables; Example 2: mysql command show tables mysql -u user -p