September 28, 2018

MySQL provides a schema named information_schema. This has a table named TABLES that has detailed information on the available tables, their record count, etc. The query below helps you with