联 系 我 们
售前咨询
售后咨询
微信关注:星环科技服务号
更多联系方式 >
4.5.5 查询数据
更新时间:6/28/2023, 9:01:22 AM
例 21. 查询 orders 中的数据
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     |
+------------+----------+-------------+-----------------+------------+--------+---------+
复制