Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

[SOLVED]: How to insert 30-50K rows into MySQL DB using DBI?

by Perl300 (Friar)
on Oct 02, 2018 at 21:57 UTC ( [id://1223430]=perlquestion: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    #!/usr/bin/perl -w
    
    use strict;
    ...
    $sth3->finish();
    
    $dbh2->disconnect();
    
  2. or download this
              ('host1', '123.456.789', 'string1', 'string4', 'Root (root@l
    +ocalhost) (configure /etc/snmp/snmp.local.conf)'),
              ('host2', '123.456.743', 'string2', 'string5', 'Root (root@l
    +ocalhost) (configure /etc/snmpDBD::mysql::st execute failed: MySQL se
    +rver has gone away at insert1.pl line 38.
    DBD::mysql::st execute failed: MySQL server has gone away at insert1.p
    +l line 38.
    /snmp.local.conf)'),
              ('host3', '499.456.789', 'string3', 'string6', 'Root (root@l
    +ocalhost) (configure /etc/snmp/snmp.local.conf)'),
    

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://1223430]
Approved by 1nickt
Front-paged by 1nickt
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others exploiting the Monastery: (2)
As of 2024-04-26 03:37 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found