Help for this page

Select Code to Download


  1. or download this
      $sth = $dbh->prepare(qq{
    INSERT INTO people (fullname, age) VALUES (?, ?)
  });
  $sth->execute("Joe Bloggs", undef);
  2. or download this
    WHERE ISNULL(age, xx) = ISNULL(?, xx)
  3. or download this
    $where_clause = defined $age? "age = ?" : "age IS NULL";