Help for this page

Select Code to Download


  1. or download this
    $ST=$DBH->prepare(<<EOSQL);
    if not exists (select * from tbl where timestamp > ?)
    ...
    EOSQL
    
    $ST->execute($timestamp, $hostname, $timestamp, $hostname, $hostname, 
    +$timestamp);
    
  2. or download this
    $ST=$DBH->prepare(<<EOSQL);
    if not exists (select * from tbl where hostname=?)
    ...
    
    $ST->execute($hostname, $hostname, $timestamp, $hostname, $timestamp,
                 $timestamp, $hostname);