Help for this page

Select Code to Download


  1. or download this
    $sql = "SELECT action_id
      FROM transactions LEFT JOIN actions 
          ON transactions.transaction_id = actions.transaction_id
    ...
    $aref = $sth->fetchrow_array;
    print join(', ', @$aref),"\n";
    $sth->finish;
    
  2. or download this
    mysql> SELECT action_id,transaction_date
        ->   FROM transactions LEFT JOIN actions 
        ->       ON transactions.transaction_id = actions.transaction_id
    ...
    |   1061498 | 2014-08-05 18:50:11 |
    +-----------+---------------------+
    1 row in set (0.00 sec)
    
  3. or download this
    $sql = "SELECT action_id
      FROM transactions LEFT JOIN actions 
          ON transactions.transaction_id = actions.transaction_id
    ...
    $sth->execute;
    $aref = $sth->fetchrow_array;
    print join(', ', @$aref),"\n";