Show the name and number of columns for all your tables mysql code example

Example 1: mysql all columns

-- MySQL
SELECT * 
FROM INFORMATION_SCHEMA.COLUMNS;

Example 2: mysql show table fields

DESCRIBE my_table;