Help for this page

Select Code to Download


  1. or download this
    use DBIx::Abstract;
    # get started using existing $DBH handle
    ...
    
    # update from a hash, auto-quoting for you
    $db->update'table_name',\%hash_ref,'item_id = 3');
    
  2. or download this
    $sth->prepare_cached("SELECT * from t where id = ?");
    $DBH->selectall_arrayref($sth, {}, @bind_values);