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.
|
---|
In Section
Seekers of Perl Wisdom