how to see datatypes of a table in mysql code example

Example: get the mysql table columns data type mysql

SHOW COLUMNS FROM mydb.mytable;