First, this has nothing to do with DBI, but seems to be some special syntax for MySQL multiple row insert, so the best thing to do would be to print the SQL statement before you execute it, to make sure you have the SQL statement that you think you do. I don't see offhand why the first example wouldn't work, and "doesn't work" is not a very good explanation of the problem.