数据操作

GBase南大通用GBase 8a MPP Cluster数据库支持数据的增、删、改、查。

执行用户需要有insert、drop、update、select权限。

#增加数据：

	gbase> INSERT INTO ssbm.lineorder (lo_orderkey, lo_linenumber, lo_custkey, lo_partkey, lo_suppkey, lo_orderdate, lo_orderpriority, lo_shippriority, lo_quantity, lo_extendedprice, lo_ordtotalprice, lo_discount, lo_revenue, lo_supplycost, lo_tax, lo_commitdate, lo_shipmode) VALUES(1, 1, 257368, 465569, 41365, 19920101, '2-HIGH', '0', 17, 2608718, 9783671, 4, 2504369, 92072, 2, 19920211, 'TRUCK');
	Query OK, 1 row affected (Elapsed: 00:00:00.53)

#删除数据：

	gbase> DELETE FROM ssbm.lineorder
		-> WHERE lo_orderkey=1 and lo_linenumber=1 ;
	Query OK, 2 rows affected (Elapsed: 00:00:00.36)

#修改数据：

	gbase> UPDATE ssbm.lineorder
		-> SET lo_orderkey=1, lo_linenumber=1, lo_custkey=257368, lo_partkey=465569, lo_suppkey=41365, lo_orderdate=19920101, lo_orderpriority='2-HIGH', lo_shippriority='0', lo_quantity=17, lo_extendedprice=2608718, lo_ordtotalprice=9783671, lo_discount=4, lo_revenue=2504369, lo_supplycost=92072, lo_tax=2, lo_commitdate=19920211, lo_shipmode='TRUCK'
		-> WHERE lo_orderkey=1 and lo_linenumber=1;
	Query OK, 2 rows affected (Elapsed: 00:00:32.24)
	Rows matched: 2  Changed: 2  Warnings: 0

#查询数据：

	gbase> SELECT lo_orderkey, lo_linenumber, lo_custkey, lo_partkey, lo_suppkey, lo_orderdate, lo_orderpriority, lo_shippriority, lo_quantity, lo_extendedprice, lo_ordtotalprice, lo_discount, lo_revenue, lo_supplycost, lo_tax, lo_commitdate, lo_shipmode
		-> FROM ssbm.lineorder WHERE lo_orderkey=1 and lo_linenumber=1;
	+-------------+---------------+------------+------------+------------+--------------+------------------+-----------------+-------------+------------------+------------------+-------------+------------+---------------+--------+---------------+-------------+
	| lo_orderkey | lo_linenumber | lo_custkey | lo_partkey | lo_suppkey | lo_orderdate | lo_orderpriority | lo_shippriority | lo_quantity | lo_extendedprice | lo_ordtotalprice | lo_discount | lo_revenue | lo_supplycost | lo_tax | lo_commitdate | lo_shipmode |
	+-------------+---------------+------------+------------+------------+--------------+------------------+-----------------+-------------+------------------+------------------+-------------+------------+---------------+--------+---------------+-------------+
	|           1 |             1 |     257368 |     465569 |      41365 |     19920101 | 2-HIGH           | 0               |          17 |          2608718 |          9783671 |           4 |    2504369 |         92072 |      2 |      19920211 | TRUCK       |
	|           1 |             1 |     257368 |     465569 |      41365 |     19920101 | 2-HIGH           | 0               |          17 |          2608718 |          9783671 |           4 |    2504369 |         92072 |      2 |      19920211 | TRUCK       |
	+-------------+---------------+------------+------------+------------+--------------+------------------+-----------------+-------------+------------------+------------------+-------------+------------+---------------+--------+---------------+-------------+
	2 rows in set (Elapsed: 00:00:00.16)

结论：GBase南大通用GBase 8a MPP Cluster数据库支持数据的增、删、改、查。