Better to get in the habit of specifying your column values:

my $insert = $dbh->prepare("insert into table
(column1, column2, column3) values (?,?,?)");
[download]

OT, but the only time I don't do this is outside of Perl where the language lets me declare record variables like a table:

define some_record like some_table.*

insert into some_table some_record.*
[download]

And even this breaks when columns get out of order between the time you compile the program and run it, so column order becomes one more thing to maintain, and it's better to not have to maintain one more thing. :)