按照官方存储库 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)
