http://qs321.pair.com?node_id=798864


in reply to Re: load data to MySQL database using Perl
in thread load data to MySQL database using Perl

Yes. Thanks a lot. When I set autocommit from "off" to "on", it worked as expected.

I checked perldoc DBI about the setting of autocommit when establishing a connection, but did not understand well. In practice in which situation the autocommit should be set to "off" and then call commit to make the transaction take effect.

Thanks again.