万里数据库分布式GreatDB Cluster SQL基本操作-数据操作

数据操作

GreatDB Cluster> insert into greatdb_cluster.t_range values(1,1),(50,50),(100,100), (200,200), (500,500), (1000,1000),(2000,2000);
Query OK, 7 rows affected (0.01 sec)
Records: 7  Duplicates: 0  Warnings: 0

GreatDB Cluster> insert into greatdb_cluster.t_hash values(1,1),(50,50),(100,100), (200,200), (500,500), (1000,1000),(2000,2000);

GreatDB Cluster> select * from t_range;
+------+------+
| c1   | c2   |
+------+------+
|    1 |    1 |
|   50 |   50 |
|  100 |  100 |
|  200 |  200 |
|  500 |  500 |
| 1000 | 1000 |
| 2000 | 2000 |
+------+------+
7 rows in set (0.00 sec)
GreatDB Cluster> delete from greatdb_cluster.t_range where c1 < 200;
Query OK, 3 rows affected (0.01 sec)
GreatDB Cluster> select * from greatdb_cluster.t_range;
+------+------+
| c1   | c2   |
+------+------+
|  200 |  200 |
|  500 |  500 |
| 1000 | 1000 |
| 2000 | 2000 |
+------+------+
4 rows in set (0.00 sec)

GreatDB Cluster> update greatdb_cluster.t_range set c2 = c2 +100;
Query OK, 4 rows affected (0.01 sec)
Rows matched: 4  Changed: 4  Warnings: 0

GreatDB Cluster> select * from greatdb_cluster.t_range;
+------+------+
| c1   | c2   |
+------+------+
|  200 |  300 |
|  500 |  600 |
| 1000 | 1100 |
| 2000 | 2100 |
+------+------+
4 rows in set (0.00 sec)

## cross-node join
GreatDB Cluster> select t1.c1, t2.c1, t1.c1+t2.c1 as sum from greatdb_cluster.t_range t1 join greatdb_cluster.t_hash t2 on t1.c1 + t2.c1 > 200 order by sum;
+------+------+------+
| c1   | c1   | sum  |
+------+------+------+
|  200 |    1 |  201 |
|    1 |  200 |  201 |
.........