What is the most effective way to use mysql?

If you want to get a list of tables in a MySQL database, use the mysql client tool to connect to the MySQL server, and issue the SHOW TABLES command. The optional FULL modifier shows the table type as the second output column. For more information, I can suggest to use how to show the tables in a database in mysql which is a really updated and useful feature and info.