my $sth = $dbh->prepare( "INSERT INTO table VALUES ( ?, ?, ?, ? )" );
      $sth->execute( 'a', 1234, undef, 't' );
      ## samething for do