mysql:select from a table from a table? code example

Example: select tables from mysql database

SHOW TABLES from <databasename>;