MySQL – Table/View Column Information

Similar to MSSQL – Table/View Column Information, this post will help with MySQL tables and columns.

This query is a quick query to give you the pertinent information about a specific table.

DESCRIBE <Table Name>;

select * from `information_schema`.`columns`
WHERE table_name = '<Table Name>';

SELECT 
    table_name,
    Replace(GROUP_CONCAT(CONCAT(column_name, ', ', table_name)),CONCAT(', ', table_name), '')
FROM
    `information_schema`.`columns`
WHERE
WHERE table_schema = '<DatabaseName>'
GROUP BY table_name;