I noticed if you specify ZEROFILL for a numeric column, MySQL automatically adds the UNSIGNED attribute to the column.

Just curiuos about the zero fill. When would you really want to use it?

Maybe the user has an integer field that must have uniform length, so they may prefer to have the leading portion fill with zeroes.
One common usage for this is creating invoice ids. (eg) All order numbers on the INT field have the same length ‘000090.
It really depends on how the sql query needs to be performed in a sql query or script.

You will need to query the information_schema in the table columns were you will give as parameter the db name and table name.then you will be able to read only the column name for that matter. You must have access to the information schema to grab this information. Good luck.