how to list all the tables in mysql code example

Example: mysql show tables in database

show tables;