Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re: Mysql smallint out of range. How to fetch warning?

by samtregar (Abbot)
on Oct 16, 2010 at 03:39 UTC ( [id://865620] : note . print w/replies, xml ) Need Help??


in reply to Mysql smallint out of range. How to fetch warning?

Just use the SHOW WARNINGS statement:

$dbh->do("CREATE TEMPORARY TABLE foo (bar SMALLINT)") $dbh->do("INSERT INTO foo (bar) VALUES (100000000)"); use Data::Dumper; print Dumper($dbh->selectall_arrayref("SHOW WARNINGS"));

Output:

$VAR1 = [ [ 'Warning', '1264', 'Out of range value adjusted for column \'bar\' at row 1' ] ];

-sam