Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

Re: DBI scanning of column definitions

by rnahi (Curate)
on Jul 16, 2005 at 09:00 UTC ( #475423=note: print w/replies, xml ) Need Help??


in reply to DBI scanning of column definitions

If you are just using MySQL, then you can benefit from some special attributes in DBD::mysql, such as mysql_is_num.

For example:

$dbh->do(qq{DROP TABLE IF EXISTS test.test1}); $dbh->do(qq{CREATE TABLE test.test1( f_int int, f_char char(10), f_double double, f_bigint BIGINT, f_varchar VARCHAR(10), f_date DATE, f_timestamp timestamp )}); my $sth= $dbh->prepare(qq{SELECT * from test.test1}); $sth->execute() or die "execution error ($DBI::errstr)\n"; my @columns = @{$sth->{NAME}}; for (0 .. $#columns) { printf "%s %s numeric\n", $columns[$_], $sth->{mysql_is_num}[$_] ? "is" : "isn't"; } __END__ output: f_int is numeric f_char isn't numeric f_double is numeric f_bigint is numeric f_varchar isn't numeric f_date isn't numeric f_timestamp isn't numeric

HTH

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://475423]
help
Chatterbox?
and the fog begins to lift...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (3)
As of 2017-12-11 23:40 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    What programming language do you hate the most?




















    Results (319 votes). Check out past polls.

    Notices?