CREATE TABLE blah (
   A INT,
   B INT NOT NULL DEFAULT 0
)

##</code><code>##

   my $query = "INSERT INTO blah SET A = ?, B = ? ";
   my $query_handle = $db_handle->prepare($query);

##</code><code>##

   my @to_insert = (
      { 'A' => 1, 'B' => 1 },
      { 'B' => 2 },
      { 'A' => 3 },
   );