DBI:mysql how to do multiple inserts/modification?

[Tomasz Chmielewski]

How can I do multiple database modifications without writing too much code?

For a single modification, I would write:

$SQL = "INSERT INTO aaaaa..";
$db->do($SQL);

How can I do it without repeating "$db->do($SQL);" each time?


Something like this throws an error, so obviously I must be missing
something.

$SQL = "INSERT INTO aaaaa... ;
INSERT INTO bbbbb... ;
INSERT INTO bbbbb... ;";
$db->do($SQL);

 

[Paul Lalli]

How can I do multiple database modifications without writing too much code?

For a single modification, I would write:

$SQL = "INSERT INTO aaaaa..";
$db->do($SQL);

How can I do it without repeating "$db->do($SQL);" each time?

Something like this throws an error, so obviously I must be missing
something.

$SQL = "INSERT INTO aaaaa... ;
        INSERT INTO bbbbb... ;
        INSERT INTO bbbbb... ;";
$db->do($SQL);

uh. How about...

for my $stmt (split /;\n/, $SQL) {
$db->do($stmt);
}

Paul Lalli

 

[John Bokma]

How can I do multiple database modifications without writing too much
code?

For a single modification, I would write:

$SQL = "INSERT INTO aaaaa..";
$db->do($SQL);

How can I do it without repeating "$db->do($SQL);" each time?

prepare the statement, and in a loop do $sth->execute( values )

 

[Tomasz Chmielewski]

uh. How about...

for my $stmt (split /;\n/, $SQL) {
$db->do($stmt);
}

Ah, that simple.
Thanks a lot.