RE: insert data with Perl into multiple MySQL tables

2004-09-17 Thread Bob Showalter
Maxipoint Rep Office wrote: > How insert data with Perl into multiple MySQL tables? You need multiple INSERT statements. Use a transaction if they all need to complete or fail together. I don't use MySQL, so I don't know how transactions work for it specifically, but typically y

insert data with Perl into multiple MySQL tables

2004-09-16 Thread Maxipoint Rep Office
How insert data with Perl into multiple MySQL tables? I can not find any clear advice.. this is for TABLE1: # Connect to the database. my $dbh = DBI->connect("DBI:mysql:database=;host=localhost", "username", "pass",