How to get the list of tables from mysql. Can anyone advice me.
either you select a database then run a SHOW TABLES command or do SHOW TABLES FROM dbname;
Next time ask database questions in the database forum
