CREATE TABLE `t_test_type` (
    `f_num` INT(11) NULL DEFAULT NULL,
    `f_str` CHAR(50) NULL DEFAULT NULL
)
ENGINE=MyISAM
;

##</code><code>##

> 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)


##</code><code>##

#!/usr/bin/env perl

use warnings;
use strict;

use DBI;

my $dsn = "DBI:mysql:database=mysql";
my $dbh = DBI->connect($dsn,
    ... , #user name and password
    { RaiseError => 1 }
) or die $DBI::errstr;

my $info = $dbh->column_info(
    undef, 'mysql', 't_test_type', '%'
)->fetchall_hashref('COLUMN_NAME');
while (my ($col, $col_info) = each %$info) {
    print "$col $col_info->{ DATA_TYPE } $col_info->{ TYPE_NAME }\n";
}

##</code><code>##

f_str 1 CHAR
f_num 4 INT