Count SQL for Data tables/fields in MySQL database

1. Query the number of fields in a table:

SELECT COUNT (*) from INFORMATION_SCHEMA. COLUMNS
WHERE table_schema = ' database name '
and table_name = ' table name ';

2. Query How many tables are in a database:

SELECT COUNT (*) TABLES, table_schema from INFORMATION_SCHEMA. TABLES WHERE table_schema = ' database name ' GROUP by Table_schema;

3. Query the number of fields in a database:

SELECT COUNT (column_name) from INFORMATION_SCHEMA. COLUMNS WHERE table_schema = ' database name ';

4. Query all the tables in a database and all fields, field types and comments, and other information:

SELECT table_name, COLUMN_NAME, Data_type, column_comment from INFORMATION_SCHEMA. COLUMNS
WHERE table_schema = ' database name ';

Count SQL for Data tables/fields in MySQL database