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

Help for this page

Select Code to Download


  1. or download this
       $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"));
    
  2. or download this
    $VAR1 = [
              [
    ...
                'Out of range value adjusted for column \'bar\' at row 1'
              ]
            ];
    

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://865620]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others studying the Monastery: (5)
As of 2024-03-29 10:50 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found