Type of Column In the Information Schema COLUMNS Table

Question

In MariaDB, what are the type of the fields in Information Schema COLUMNS Table ? I can't find it in the mariadb documentation

user_17645099 · Answer

This should work:

SHOW FIELDS FROM INFORMATION_SCHEMA.COLUMNS

user_11894831 · Answer

Ok, i'm stupid. Obviously:

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = "INFORMATION_SCHEMA" AND TABLE_NAME = "COLUMNS";