Get Column Name, Column Data Type and Column Length from MySQL Database

USE information_schema;

SELECT
COLUMN_NAME,
DATA_TYPE,
COLUMN_TYPE
FROM COLUMNS
WHERE TABLE_NAME = 'account_registration'