view release on metacpan or  search on metacpan

lib/Egg/Mod/EasyDBI.pm  view on Meta::CPAN

  $table->find_insert( user=> 'banban', age=> 20 );
  
  # SELECT id FROM $table WHERE id = 1
  # INSERT INTO $table (user, age) VALUES ('banban', 20)
  $table->find_insert(\'id', { id=> [1], user=> 'banban', age=> 20 });
    or
  $table->find_insert( id=> [1], user=> 'banban', age=> 20 );

=head2 for_update ([PRIMARY_KEY], [VALUE])

The record by FOR UPDATE is locked.

0 returns when failing.

  # SELECT * FROM $table WHERE id = ? FOR UPDATE
  $table->for_update( id=> 1 );

=head2 delete ([STATEMENT], [EXECUTE_ARGS])

The record is deleted.