MySQL View table type notes

SELECT
COLUMN_NAME,
Data_type as ' data type ',
Character_maximum_length as ' character length ',
Numeric_precision as ' digital length ',
Numeric_scale as ' number of decimal digits ',
Is_nullable as ' allow non-null ',
case if EXTRA = ' auto_increment ' then 1 ELSE 0 END as ' whether self-increment ',
Column_default as ' default value ',
Column_comment as ' remarks '
From INFORMATION_SCHEMA. COLUMNS WHERE table_name= ' battlefield_decision '

MySQL View table type notes