docker安装oceanbase-ce
·
按照官方存储库 https://github.com/oceanbase/oceanbase/ 的说明
docker run -p 2881:2881 --name oceanbase-ce -e MODE=mini -d quay.io/oceanbase/oceanbase-ce
Trying to pull quay.io/oceanbase/oceanbase-ce:latest...
Getting image source signatures
Copying blob 4f4fb700ef54 skipped: already exists
Copying blob 6728bf757e31 done
Copying blob 54273d8675f3 done
Copying blob 2efd70a35384 done
Copying blob 72ee1022ca9b done
Copying blob a82121c3f71c done
Copying blob 445ce7ca8c79 done
Copying blob e9f1938383fe done
Copying blob a79d63ec3340 done
Copying blob 8ebd046c2d04 done
Copying blob 8c3dfb3c9ec9 done
Copying blob 3ce39581b024 done
Copying blob e2bc6002f07a done
Copying blob 1c0caaab7740 done
Copying blob 62a271553270 done
Copying blob f6cd8d3a5322 done
Copying blob 4231d32e6426 done
Copying blob 6097e28a5581 done
Copying blob 14e5b691fa32 done
Copying blob a331b8c8fc22 done
Copying blob a89ad9e2f6ce done
Copying config 2049186443 done
Writing manifest to image destination
Storing signatures
22d8502f840462d52cd6143ca3ac34d1fd1bc63f6273d61690fff5de7b12f82e
docker image list -a|grep oce
quay.io/oceanbase/oceanbase-ce latest 2049186443c1 4 weeks ago 1.55 GB
docker exec -it oceanbase-ce obclient -h127.0.0.1 -P2881 -uroot
Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 3221518882
Server version: OceanBase_CE 4.3.5.5 (r105000012025111711-c10174c0486c38f64a2222486986bbe15d5da0dc) (Built Nov 17 2025 12:20:08)
Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
obclient(root@(none))[(none)]> select version();
+------------------------------+
| version() |
+------------------------------+
| 5.7.25-OceanBase_CE-v4.3.5.5 |
+------------------------------+
1 row in set (0.002 sec)
obclient(root@(none))[(none)]>
obclient(root@(none))[(none)]> with recursive t as(select 1 a union all select a+1 from t where a<3)select * from t;
+------+
| a |
+------+
| 1 |
| 2 |
| 3 |
+------+
3 rows in set (0.012 sec)
obclient(root@(none))[(none)]> select 1 << 3, 1&& 6, 1^5 ;
+--------+-------+------+
| 1 << 3 | 1&& 6 | 1^5 |
+--------+-------+------+
| 8 | 1 | 4 |
+--------+-------+------+
1 row in set (0.005 sec)
obclient(root@(none))[(none)]> select [1,2,3];
+---------+
| [1,2,3] |
+---------+
| [1,2,3] |
+---------+
1 row in set (0.015 sec)
更多推荐
所有评论(0)