Querying all column information from all entities in a MySQL Database

column_info.sql

SELECT 
    table_name, 
    column_name, 
    data_type, 
    character_maximum_length, 
    numeric_precision, 
    numeric_scale, 
    column_type, 
    column_key, 
    extra, 
    is_nullable 
FROM 
    information_schema.columns 
WHERE 
    table_schema='<database_name>' 
ORDER BY 
    table_name,
    ordinal_position;