CODE EXAMPLE FOR SQL

get the mysql table columns data type mysql

SHOW COLUMNS FROM mydb.mytable;