Help for this page

Select Code to Download


  1. or download this
    update table set ID = 10 where ID = 5"
    
  2. or download this
    my $update_sth = $dbh->prepare( "update table set ID=? where ID=5 and 
    +Name=?");
    my $select_sth = $dbh->prepare( "select Name from table where ID=5" );
    ...
        my $name = $$row[0];
        $update_sth->execute( $new_ID++, $name );
    }