select trans_id , acc_num ,trans_time ,trans_type ,stock_id , price ,amount from orders;
复制
返回结果:
+------------+----------+-------------+-----------------+------------+--------+---------+ | trans_id | acc_num | trans_time | trans_type | stock_id | price | amount | +------------+----------+-------------+-----------------+------------+--------+---------+ | 719753265 | 3912384 | 2014-03-28 | b MERGE update | BY8490909 | 68.43 | 100 | | 209441379 | 3912384 | 2014-04-30 | s MERGE update | CX5397790 | 4.5 | 1000 | | 648230055 | 700735 | 2014-03-15 | s MERGE insert | DT7966575 | 22.66 | 200 | | 929634984 | 3912384 | 2014-02-05 | b | UA1467891 | 11.11 | 300 | | 929634977 | 3912377 | 2014-02-05 | b | UA1467877 | 11.77 | 300 | | 929634984 | 3912384 | 2014-02-06 | d | UA1467891 | 11.11 | 300 | | 499506900 | 6513065 | 2014-05-06 | s | CA2789982 | 6.12 | 100 | +------------+----------+-------------+-----------------+------------+--------+---------+
复制