> SELECT column_name, data_type FROM information_schema.columns
WHERE table_name = 't_test_type' AND column_name IN ('f_num', 'f_str');

+-------------+-----------+
| column_name | data_type |
+-------------+-----------+
| f_num       | int       |
| f_str       | char      |
+-------------+-----------+
2 rows in set (0.00 sec)