show comments in all tables type in mysqldb code example Example: get the mysql table columns data type mysql SHOW COLUMNS FROM mydb.mytable;