[TOC]
# 算術運算符
以下為所有算術運算符列表:
<table data-tag="table" id="table-y8m-guy-1m8" class="table"><colgroup data-tag="col" id="col-n7e-75m-etx" colwidth="1*" colnum="1" colname="col1" style="width:33.33333333333333%" class="col"></colgroup><colgroup data-tag="col" id="col-orp-uf4-72j" colwidth="1*" colnum="2" colname="col2" style="width:33.33333333333333%" class="col"></colgroup><colgroup data-tag="col" id="col-xj4-nqa-r1v" colwidth="1*" colnum="3" colname="col3" style="width:33.33333333333333%" class="col"></colgroup><thead id="thead-8so-3ko-7bu" class="thead"><tr id="tr-11b-tli-gtl"><th id="td-i5f-jtd-qyz"><p id="p-cj5-vi4-fqv">運算符</p></th><th id="td-abr-tx3-aou"><p id="p-8jt-5ft-7r7">操作數</p></th><th id="td-r9c-o74-eps"><p id="p-9ze-m3t-acp">含義</p></th></tr></thead><tbody data-tag="tbody" id="tbody-wbo-qyj-0s7" class="tbody"><tr data-tag="tr" id="tr-69l-fsa-dk6" class="tr"><td data-tag="td" id="td-it1-b9d-1jz" class="td"><p id="p-s2g-nj1-7z2"><code data-tag="code" class="code">+</code></p></td><td data-tag="td" id="td-45a-rf5-8ak" class="td"><p id="p-bm4-fmq-paq">一元/二元</p></td><td data-tag="td" id="td-b8z-ptf-cji" class="td"><p id="p-7si-bts-s3n">一元表示正數,二元表示加法。</p></td></tr><tr data-tag="tr" id="tr-puc-oaj-i3j" class="tr"><td data-tag="td" id="td-k41-dnu-sa8" class="td"><p id="p-8nc-4rs-cwx"><code data-tag="code" class="code">-</code></p></td><td data-tag="td" id="td-6vw-8fw-0oh" class="td"><p id="p-w3t-ymz-nup">一元/二元</p></td><td data-tag="td" id="td-pm6-qi4-k0q" class="td"><p id="p-35q-no8-ndl">一元表示負數,二元表示減法。</p></td></tr><tr data-tag="tr" id="tr-vp7-1pi-egc" class="tr"><td data-tag="td" id="td-8em-6vk-k8w" class="td"><p id="p-tkf-sdo-wua"><code data-tag="code" class="code">*</code></p></td><td data-tag="td" id="td-aa9-e0b-omr" class="td"><p id="p-0hr-sa3-lxh">二元</p></td><td data-tag="td" id="td-bm9-7l8-ss0" class="td"><p id="p-mhs-n17-4c0">乘法。</p></td></tr><tr data-tag="tr" id="tr-swi-8yp-eec" class="tr"><td data-tag="td" id="td-xhg-yh7-3y7" class="td"><p id="p-51c-06f-jve"><code data-tag="code" class="code">/</code></p></td><td data-tag="td" id="td-j7g-xpm-29o" class="td"><p id="p-u29-w1o-mz4">二元</p></td><td data-tag="td" id="td-s0c-00m-kd4" class="td"><p id="p-46p-utr-xba">普通除法。</p></td></tr><tr data-tag="tr" id="tr-rv3-jbl-qh4" class="tr"><td data-tag="td" id="td-514-1ww-fqy" class="td"><p id="p-vc7-w0s-g2g"><code data-tag="code" class="code">DIV</code></p></td><td data-tag="td" id="td-vht-ht2-lfu" class="td"><p id="p-3mi-1t5-spm">二元</p></td><td data-tag="td" id="td-d4m-d06-qsp" class="td"><p id="p-ttw-075-mty">整數除法,返回商數。</p></td></tr><tr data-tag="tr" id="tr-pys-uzd-ed7" class="tr"><td data-tag="td" id="td-lt6-7ud-xuv" class="td"><p id="p-o8x-3fc-5rz"><code data-tag="code" class="code">MOD</code>或<code data-tag="code" class="code">%</code></p></td><td data-tag="td" id="td-lla-g3i-nfm" class="td"><p id="p-jaf-jfw-lvi">二元</p></td><td data-tag="td" id="td-2tv-1p6-ji6" class="td"><p id="p-w91-v41-foh">整數除法,返回余數。</p></td></tr></tbody></table>
整數除法遵循如下原則:
* 商數不論正負,統一向0取整。
* 余數正負與被除數相同。
例如:
~~~
OceanBase (root@oceanbase)> SELECT (-7) DIV (3.6), (-7) MOD (3.6);
+----------------+----------------+
| (-7) DIV (3.6) | (-7) MOD (3.6) |
+----------------+----------------+
| -1 | -3.4 |
+----------------+----------------+
1 row in set (0.01 sec)
OceanBase (root@oceanbase)> SELECT (-7) DIV (-3.4), (-7) % (-3.4);
+-----------------+---------------+
| (-7) DIV (-3.4) | (-7) % (-3.4) |
+-----------------+---------------+
| 2 | -0.2 |
+-----------------+---------------+
1 row in set (0.02 sec)
~~~
# 位運算符
位運算使用`BIGINT UNSIGNED`計算,不需考慮符號位。
以下為所有位運算符列表:
<table data-tag="table" id="table-y02-7n1-bm2" class="table"><colgroup data-tag="col" id="col-pbv-1z5-p8o" colwidth="1*" colnum="1" colname="col1" style="width:33.33333333333333%" class="col"></colgroup><colgroup data-tag="col" id="col-bwk-yb5-oji" colwidth="1*" colnum="2" colname="col2" style="width:33.33333333333333%" class="col"></colgroup><colgroup data-tag="col" id="col-m2l-zv6-h5k" colwidth="1*" colnum="3" colname="col3" style="width:33.33333333333333%" class="col"></colgroup><thead id="thead-sbs-cyo-0pv" class="thead"><tr id="tr-s9j-pue-7uk"><th id="td-w41-0pa-pw4"><p id="p-cw1-cdz-tn3">運算符</p></th><th id="td-pt5-hqi-vbn"><p id="p-07s-8w1-n47">操作數</p></th><th id="td-10o-hb1-3af"><p id="p-auv-xua-y2a">含義</p></th></tr></thead><tbody data-tag="tbody" id="tbody-4fu-fjq-pwi" class="tbody"><tr data-tag="tr" id="tr-5dn-5nr-zna" class="tr"><td data-tag="td" id="td-ok8-wv0-eg8" class="td"><p id="p-69r-w1s-e55"><code data-tag="code" class="code">&amp;</code></p></td><td data-tag="td" id="td-446-59n-jp0" class="td"><p id="p-gn8-tph-mxq">二元</p></td><td data-tag="td" id="td-jdg-2f4-nsc" class="td"><p id="p-zkl-i94-7cf">按位與。</p></td></tr><tr data-tag="tr" id="tr-92i-cva-oeq" class="tr"><td data-tag="td" id="td-anc-e81-kj5" class="td"><p id="p-cvx-v9t-4en"><code data-tag="code" class="code">|</code></p></td><td data-tag="td" id="td-lo4-k5e-tqc" class="td"><p id="p-bcq-dve-kej">二元</p></td><td data-tag="td" id="td-f68-x16-2ty" class="td"><p id="p-lba-jgl-l89">按位或。</p></td></tr><tr data-tag="tr" id="tr-7e0-40n-sal" class="tr"><td data-tag="td" id="td-xau-dqa-zi4" class="td"><p id="p-yq1-5v4-stn"><code data-tag="code" class="code">~</code></p></td><td data-tag="td" id="td-8cy-rdo-tbp" class="td"><p id="p-uo2-ys7-0d4">一元</p></td><td data-tag="td" id="td-7lq-wsn-ovi" class="td"><p id="p-8vm-psx-pvc">按位取反。</p></td></tr><tr data-tag="tr" id="tr-3vr-dhi-m8h" class="tr"><td data-tag="td" id="td-npq-eki-rpz" class="td"><p id="p-q2w-3ha-o1t"><code data-tag="code" class="code">^</code></p></td><td data-tag="td" id="td-mw1-qwi-t1s" class="td"><p id="p-6d2-qb8-7u8">二元</p></td><td data-tag="td" id="td-cto-muj-v40" class="td"><p id="p-k96-rry-h17">按位異或。</p></td></tr><tr data-tag="tr" id="tr-7ca-9xw-evo" class="tr"><td data-tag="td" id="td-y0n-qon-wjv" class="td"><p id="p-63n-th8-29m"><code data-tag="code" class="code">&lt;&lt;</code></p></td><td data-tag="td" id="td-3uz-vqe-umq" class="td"><p id="p-wzr-pg1-mwx">二元</p></td><td data-tag="td" id="td-th4-gw7-t34" class="td"><p id="p-urt-yqp-5p8">邏輯左移。</p></td></tr><tr data-tag="tr" id="tr-q0a-3bp-fx0" class="tr"><td data-tag="td" id="td-rth-wki-kja" class="td"><p id="p-55f-o5e-xur"><code data-tag="code" class="code">&gt;&gt;</code></p></td><td data-tag="td" id="td-yfv-59d-sv2" class="td"><p id="p-0d4-xnd-syz">二元</p></td><td data-tag="td" id="td-ymq-pqy-647" class="td"><p id="p-apx-8eo-pvh">邏輯右移。</p></td></tr></tbody></table>
# 比較運算符
以下為所有比較運算符列表:
<table data-tag="table" id="table-y2x-mir-8do" class="table"><colgroup data-tag="col" id="col-vdb-127-gh0" colwidth="1*" colnum="1" colname="col1" style="width:25%" class="col"></colgroup><colgroup data-tag="col" id="col-jr6-kpn-m29" colwidth="1*" colnum="2" colname="col2" style="width:25%" class="col"></colgroup><colgroup data-tag="col" id="col-6zt-k9l-nhw" colwidth="1*" colnum="3" colname="col3" style="width:25%" class="col"></colgroup><colgroup data-tag="col" id="col-cib-0sm-of8" colwidth="1*" colnum="4" colname="col4" style="width:25%" class="col"></colgroup><thead id="thead-5mt-7ui-cx1" class="thead"><tr id="tr-2nr-jkd-uzt"><th id="td-x8z-yt4-f60"><p id="p-kxq-aao-fua">運算符</p></th><th id="td-3t4-m68-k8f"><p id="p-q6n-ude-fsy">操作數</p></th><th id="td-338-8qs-vun"><p id="p-b2m-fd2-v3l">含義</p></th><th id="td-urt-p25-xn1"><p id="p-1cl-ucg-hab">NULL參與運算</p></th></tr></thead><tbody data-tag="tbody" id="tbody-xwa-4uc-gms" class="tbody"><tr data-tag="tr" id="tr-w5j-lv6-nka" class="tr"><td data-tag="td" id="td-fd8-bul-kq2" class="td"><p id="p-7az-ur3-j0i"><code data-tag="code" class="code">=</code></p></td><td data-tag="td" id="td-2kt-vi8-8xn" class="td"><p id="p-7hg-0bs-dfn">二元</p></td><td data-tag="td" id="td-8bm-c76-6zn" class="td"><p id="p-may-p2d-od3">等于。</p></td><td data-tag="td" id="td-eq1-ue5-tq9" class="td"><p id="p-cw3-6qu-xrb">結果為NULL。</p></td></tr><tr data-tag="tr" id="tr-v3w-k66-yo9" class="tr"><td data-tag="td" id="td-6d1-rda-wqb" class="td"><p id="p-lw4-c1s-4nb"><code data-tag="code" class="code">&lt;&gt;</code>/<code data-tag="code" class="code">!=</code></p></td><td data-tag="td" id="td-d3n-wix-v3v" class="td"><p id="p-j04-hru-qmp">二元</p></td><td data-tag="td" id="td-4dk-bhk-5i8" class="td"><p id="p-92r-acg-qoi">不等于。</p></td><td data-tag="td" id="td-cfq-f1m-o19" class="td"><p id="p-x9s-cym-yg2">結果為NULL。</p></td></tr><tr data-tag="tr" id="tr-g4z-j9l-f5i" class="tr"><td data-tag="td" id="td-stx-3rv-3mj" class="td"><p id="p-jxf-wye-qpk"><code data-tag="code" class="code">&gt;</code></p></td><td data-tag="td" id="td-hrz-uy4-6vs" class="td"><p id="p-6gf-6z8-taj">二元</p></td><td data-tag="td" id="td-3xn-ict-7xm" class="td"><p id="p-vbx-3jg-f33">大于。</p></td><td data-tag="td" id="td-22m-huw-15e" class="td"><p id="p-xud-eb4-fro">結果為NULL。</p></td></tr><tr data-tag="tr" id="tr-9si-cmi-y77" class="tr"><td data-tag="td" id="td-xj6-y4g-nxq" class="td"><p id="p-q33-x46-y60"><code data-tag="code" class="code">&gt;=</code></p></td><td data-tag="td" id="td-n8c-xte-lbs" class="td"><p id="p-og9-zdw-smd">二元</p></td><td data-tag="td" id="td-ae7-zj9-vcg" class="td"><p id="p-50c-32k-n22">大于等于。</p></td><td data-tag="td" id="td-u6i-zym-wqc" class="td"><p id="p-pr8-jut-8tr">結果為NULL。</p></td></tr><tr data-tag="tr" id="tr-sn0-rbs-8v5" class="tr"><td data-tag="td" id="td-13m-iqs-7rz" class="td"><p id="p-5gg-arb-fxr"><code data-tag="code" class="code">&lt;</code></p></td><td data-tag="td" id="td-xfh-985-le2" class="td"><p id="p-4wm-spb-jvh">二元</p></td><td data-tag="td" id="td-wb7-wpp-3rj" class="td"><p id="p-zip-z9y-fgy">小于。</p></td><td data-tag="td" id="td-1o0-sng-hsn" class="td"><p id="p-drf-nxr-m5j">結果為NULL。</p></td></tr><tr data-tag="tr" id="tr-kd8-xul-tlb" class="tr"><td data-tag="td" id="td-u6a-g4d-jt3" class="td"><p id="p-yz8-xpv-q12"><code data-tag="code" class="code">&lt;=</code></p></td><td data-tag="td" id="td-ts3-abl-1w5" class="td"><p id="p-o41-l0z-jbn">二元</p></td><td data-tag="td" id="td-632-53w-lf4" class="td"><p id="p-74e-7jv-o0h">小于等于。</p></td><td data-tag="td" id="td-3bo-07k-0od" class="td"><p id="p-cg2-z51-ykc">結果為NULL。</p></td></tr><tr data-tag="tr" id="tr-xr8-i2u-28w" class="tr"><td data-tag="td" id="td-xql-1ks-nyr" class="td"><p id="p-caz-pd9-oj3"><code data-tag="code" class="code">[NOT] IN</code></p></td><td data-tag="td" id="td-u9d-aoy-w6n" class="td"><p id="p-34x-wsn-mox">二元</p></td><td data-tag="td" id="td-lrs-a23-lyl" class="td"><p id="p-jeg-k78-mh3">是否在集合中。</p></td><td data-tag="td" id="td-jc4-uyc-ewn" class="td"><p id="p-sur-f5e-ma8">詳見說明。</p></td></tr><tr data-tag="tr" id="tr-r0d-pyi-c8j" class="tr"><td data-tag="td" id="td-nhk-vkp-8vo" class="td"><p id="p-77g-hg3-4qz"><code data-tag="code" class="code">[NOT] BETWEEN AND</code></p></td><td data-tag="td" id="td-yd8-xlz-spi" class="td"><p id="p-d9t-wdq-xvh">三元</p></td><td data-tag="td" id="td-q4e-zr5-umh" class="td"><p id="p-2az-l2g-dj3">是否在區間內。</p></td><td data-tag="td" id="td-2rr-ha1-biz" class="td"><p id="p-zwh-8fp-g3r">詳見說明。</p></td></tr><tr data-tag="tr" id="tr-rh4-716-u22" class="tr"><td data-tag="td" id="td-sot-mnu-oj1" class="td"><p id="p-8am-2xc-bh0"><code data-tag="code" class="code">IS [NOT] TRUE</code></p></td><td data-tag="td" id="td-7g0-6xp-5ew" class="td"><p id="p-ue4-5if-rgf">一元</p></td><td data-tag="td" id="td-e3z-u86-or4" class="td"><p id="p-0v4-6nu-ugn">是否等于TRUE。</p></td><td data-tag="td" id="td-c16-c16-o1m" class="td"><p id="p-gc1-yxs-zmd">結果為TRUE或FALSE。</p></td></tr><tr data-tag="tr" id="tr-p6h-v65-qgw" class="tr"><td data-tag="td" id="td-1o1-78a-c75" class="td"><p id="p-zti-hyj-cml"><code data-tag="code" class="code">IS [NOT] FALSE</code></p></td><td data-tag="td" id="td-o5y-lav-bnu" class="td"><p id="p-er1-38i-qub">一元</p></td><td data-tag="td" id="td-irq-5lb-nhp" class="td"><p id="p-3np-gf2-qvh">是否等于FALSE。</p></td><td data-tag="td" id="td-eob-vaj-t1m" class="td"><p id="p-piz-q6s-wp8">結果為TRUE或FALSE。</p></td></tr><tr data-tag="tr" id="tr-7e7-g2r-hlt" class="tr"><td data-tag="td" id="td-3qt-dq6-low" class="td"><p id="p-6ua-h0w-xtw"><code data-tag="code" class="code">IS [NOT] NULL</code></p></td><td data-tag="td" id="td-mxv-5ue-h5q" class="td"><p id="p-iip-2n6-b77">一元</p></td><td data-tag="td" id="td-s75-gu2-q1n" class="td"><p id="p-6oo-uw6-7tf">是否等于NULL。</p></td><td data-tag="td" id="td-y0w-r3m-gbe" class="td"><p id="p-co0-77b-glq">結果為TRUE或FALSE。</p></td></tr><tr data-tag="tr" id="tr-ng3-zbv-frg" class="tr"><td data-tag="td" id="td-kgf-bpt-f16" class="td"><p id="p-4hm-0u6-9d6"><code data-tag="code" class="code">&lt;=&gt;</code></p></td><td data-tag="td" id="td-ll2-9hk-yh2" class="td"><p id="p-46r-uon-iao">二元</p></td><td data-tag="td" id="td-mk9-pj7-pp8" class="td"><p id="p-0w2-g8a-uex">安全等于。</p></td><td data-tag="td" id="td-zs0-no4-rch" class="td"><p id="p-037-r06-c8m">結果為TRUE或FALSE。</p></td></tr></tbody></table>
# 邏輯運算符
以下為所有邏輯運算符列表:
<table data-tag="table" id="table-rls-0v9-rxr" class="table"><colgroup data-tag="col" id="col-k3v-l5n-zw1" colwidth="1*" colnum="1" colname="col1" style="width:33.33333333333333%" class="col"></colgroup><colgroup data-tag="col" id="col-257-msn-3oc" colwidth="1*" colnum="2" colname="col2" style="width:33.33333333333333%" class="col"></colgroup><colgroup data-tag="col" id="col-lss-3p9-6un" colwidth="1*" colnum="3" colname="col3" style="width:33.33333333333333%" class="col"></colgroup><thead id="thead-ivc-g0r-1o2" class="thead"><tr id="tr-evx-106-rcp"><th id="td-sp2-n4r-7ac"><p id="p-sbi-73p-ll9">運算符</p></th><th id="td-xyh-x6i-ph4"><p id="p-kgn-7xz-hja">操作數</p></th><th id="td-478-o2r-iqx"><p id="p-e79-qnt-gbj">含義</p></th></tr></thead><tbody data-tag="tbody" id="tbody-qf6-6kp-mzc" class="tbody"><tr data-tag="tr" id="tr-mt9-xvh-ulq" class="tr"><td data-tag="td" id="td-4da-6zc-fwd" class="td"><p id="p-svb-rko-hkn"><code data-tag="code" class="code">AND</code>/<code data-tag="code" class="code">&amp;&amp;</code></p></td><td data-tag="td" id="td-d99-v1g-qeh" class="td"><p id="p-kxm-a4g-22m">二元</p></td><td data-tag="td" id="td-a11-m6t-lzs" class="td"><p id="p-q1q-lxp-qnr">邏輯與</p></td></tr><tr data-tag="tr" id="tr-uyp-dtx-cei" class="tr"><td data-tag="td" id="td-o4u-bpr-ph2" class="td"><p id="p-khm-fr6-yof"><code data-tag="code" class="code">OR</code>/<code data-tag="code" class="code">||</code></p></td><td data-tag="td" id="td-qjf-vma-brq" class="td"><p id="p-ju0-crd-dty">二元</p></td><td data-tag="td" id="td-f02-int-5q5" class="td"><p id="p-df6-aer-3kg">邏輯或</p></td></tr><tr data-tag="tr" id="tr-0gb-e0y-s47" class="tr"><td data-tag="td" id="td-ofe-k5q-i1h" class="td"><p id="p-x2v-qt3-usk"><code data-tag="code" class="code">NOT</code>/<code data-tag="code" class="code">!</code></p></td><td data-tag="td" id="td-0xt-9oz-zhg" class="td"><p id="p-o4o-u68-2dx">一元</p></td><td data-tag="td" id="td-bbp-0yu-487" class="td"><p id="p-d2s-1km-uwh">邏輯非</p></td></tr></tbody></table>
# 日期時間運算符
以下為所有日期時間運算符列表:
<table data-tag="table" id="table-kma-swc-4n0" class="table"><colgroup data-tag="col" id="col-oza-qgz-ff8" colwidth="1*" colnum="1" colname="col1" style="width:33.33333333333333%" class="col"></colgroup><colgroup data-tag="col" id="col-56h-hue-7s9" colwidth="1*" colnum="2" colname="col2" style="width:33.33333333333333%" class="col"></colgroup><colgroup data-tag="col" id="col-jid-r07-d7n" colwidth="1*" colnum="3" colname="col3" style="width:33.33333333333333%" class="col"></colgroup><thead id="thead-8ox-ws1-vk4" class="thead"><tr id="tr-s1x-k20-2kf"><th id="td-yjk-dqu-jj7"><p id="p-sva-ppm-bxi">運算符</p></th><th id="td-bzx-dvc-ml4"><p id="p-mt5-5xs-ulw">操作數</p></th><th id="td-w53-7qt-ggl"><p id="p-ln7-ovk-45f">含義</p></th></tr></thead><tbody data-tag="tbody" id="tbody-poz-8bg-x2y" class="tbody"><tr data-tag="tr" id="tr-o7s-4sj-u2f" class="tr"><td data-tag="td" id="td-5oa-fh8-hn6" class="td"><p id="p-34r-ahi-00j"><code data-tag="code" class="code">+</code></p></td><td data-tag="td" id="td-rjx-9cd-zb9" class="td"><p id="p-hx1-arn-v9u">二元</p></td><td data-tag="td" id="td-toy-r9r-9in" class="td"><p id="p-vd3-2at-thk">同<code data-tag="code" class="code">DATE_ADD</code>函數</p></td></tr><tr data-tag="tr" id="tr-xwp-a4o-mwp" class="tr"><td data-tag="td" id="td-9kr-k5d-0v3" class="td"><p id="p-54g-svq-lad"><code data-tag="code" class="code">-</code></p></td><td data-tag="td" id="td-7fn-6nf-qef" class="td"><p id="p-0qp-ixt-zkg">二元</p></td><td data-tag="td" id="td-c8q-xx6-xw2" class="td"><p id="p-5ky-cg0-xs0">同<code data-tag="code" class="code">DATE_SUB</code>函數</p></td></tr></tbody></table>
例如:
~~~
OceanBase (root@oceanbase)> SELECT '2008-12-31 23:59:59' + INTERVAL 1 SECOND;
+-------------------------------------------+
| '2008-12-31 23:59:59' + INTERVAL 1 SECOND |
+-------------------------------------------+
| 2009-01-01 00:00:00 |
+-------------------------------------------+
1 row in set (0.01 sec)
~~~
# 字符連接運算符
以下為所有字符連接運算符列表:
<table data-tag="table" id="table-7tg-bcv-ahk" class="table"><colgroup data-tag="col" id="col-c4v-hns-8op" colwidth="1*" colnum="1" colname="col1" style="width:33.33333333333333%" class="col"></colgroup><colgroup data-tag="col" id="col-tf7-duu-mon" colwidth="1*" colnum="2" colname="col2" style="width:33.33333333333333%" class="col"></colgroup><colgroup data-tag="col" id="col-mcw-zcc-llm" colwidth="1*" colnum="3" colname="col3" style="width:33.33333333333333%" class="col"></colgroup><thead id="thead-5sj-njl-1ac" class="thead"><tr id="tr-v5g-jl9-s0v"><th id="td-fgh-4ma-zm3"><p id="p-1lu-8hy-gzd">運算符</p></th><th id="td-e4e-pe8-ydg"><p id="p-gvg-yc3-r7g">操作數</p></th><th id="td-uuo-awd-c9w"><p id="p-k9a-b8p-h7d">含義</p></th></tr></thead><tbody data-tag="tbody" id="tbody-ewt-lif-gkh" class="tbody"><tr data-tag="tr" id="tr-rt5-u37-6yx" class="tr"><td data-tag="td" id="td-dnn-20o-mzl" class="td"><p id="p-1d3-xi0-vmu"><code data-tag="code" class="code">||</code></p></td><td data-tag="td" id="td-t1j-ben-ftq" class="td"><p id="p-v09-3p7-xmq">二元</p></td><td data-tag="td" id="td-f1u-auq-n4x" class="td"><p id="p-f70-odm-lsn">字符串連接</p></td></tr></tbody></table>
如前節所述,`||`也可作為邏輯或運算符,兩個不同含義是通過SQL MODE控制的:
* SQL MODE包含`PIPES_AS_CONCAT`時,`||`為字符連接運算符。
* SQL MODE不包含`PIPES_AS_CONCAT`時,`||`為邏輯與運算符
# 層次查詢運算符
以下為所有層次查詢運算符列表:
<table data-tag="table" id="table-tt8-q9d-56l" class="table"><colgroup data-tag="col" id="col-s4h-624-4c2" colwidth="1*" colnum="2" colname="col2" style="width:33.33333333333333%" class="col"></colgroup><colgroup data-tag="col" id="col-t96-nor-36k" colwidth="1*" colnum="3" colname="col3" style="width:33.33333333333333%" class="col"></colgroup><thead id="thead-z5b-77r-4sp" class="thead"><tr id="tr-59s-siq-wrb"><th id="td-rcz-3as-23s"><p id="p-bae-urk-kza">運算符</p></th><th id="td-2ln-11j-c60"><p id="p-2jw-mt1-ozc">操作數</p></th><th id="td-ybz-fqu-ykj"><p id="p-9l1-d0c-sdk">含義</p></th></tr></thead><tbody data-tag="tbody" id="tbody-ebc-3ns-m63" class="tbody"><tr data-tag="tr" id="tr-w57-rs9-8sa" class="tr"><td data-tag="td" id="td-vl3-qt3-72b" class="td"><p id="p-wuf-hjj-09n"><code data-tag="code" class="code">PRIOR</code></p></td><td data-tag="td" id="td-j7f-3ci-ifk" class="td"><p id="p-aiu-fh4-0g3">一元</p></td><td data-tag="td" id="td-q4a-jkn-nqr" class="td"><p id="p-6ri-p16-zp6">用于指明column來自parent row</p></td></tr><tr data-tag="tr" id="tr-vvn-z1u-66y" class="tr"><td data-tag="td" id="td-alq-6ot-cg8" class="td"><p id="p-yvs-5h7-473"><code data-tag="code" class="code">CONNECT_BY_ROOT</code></p></td><td data-tag="td" id="td-ela-a4f-6ms" class="td"><p id="p-9rs-1o0-fkj">一元</p></td><td data-tag="td" id="td-wny-h4a-9k2" class="td"><p id="p-b7m-mgd-k52">用于指明頂層祖先</p></td></tr></tbody></table>
# 排序規則運算符
以下為所有排序規則運算符列表:
<table data-tag="table" id="table-ej7-j1x-tk2" class="table"><colgroup data-tag="col" id="col-632-pdg-f7v" colwidth="1*" colnum="1" colname="col1" style="width:33.33333333333333%" class="col"></colgroup><colgroup data-tag="col" id="col-ul9-2hm-w46" colwidth="1*" colnum="2" colname="col2" style="width:33.33333333333333%" class="col"></colgroup><colgroup data-tag="col" id="col-x3l-xlh-g0i" colwidth="1*" colnum="3" colname="col3" style="width:33.33333333333333%" class="col"></colgroup><thead id="thead-j9k-5kx-52y" class="thead"><tr id="tr-vh4-jqc-07i"><th id="td-wjb-0q3-lgf"><p id="p-1zd-w7i-gdb">運算符</p></th><th id="td-2kh-t9k-t6e"><p id="p-2d3-8tm-hkl">操作數</p></th><th id="td-dlr-g0w-wlz"><p id="p-8wz-whl-n89">含義</p></th></tr></thead><tbody data-tag="tbody" id="tbody-hax-ld9-5sc" class="tbody"><tr data-tag="tr" id="tr-5ok-pkc-p9j" class="tr"><td data-tag="td" id="td-yy5-oai-a1e" class="td"><p id="p-uj2-vjx-0hx"><code data-tag="code" class="code">COLLATE</code></p></td><td data-tag="td" id="td-lic-6jr-6tg" class="td"><p id="p-fp8-je8-3hn">一元(后綴)</p></td><td data-tag="td" id="td-oz4-onk-bxp" class="td"><p id="p-3nx-7vx-u1o">排序規則</p></td></tr></tbody></table>
例如:
~~~
SELECT last_name
FROM employees
ORDER BY last_name COLLATE UTF8MB4_GENERAL_CI;
~~~
- 前言
- 1.說明
- 2.文檔更新說明
- docker
- 01.docker安裝
- 02.docker加速器
- 03.docker基本使用
- 04.docker 鏡像與容器
- 05.Dockerfile
- 06.docker阿里鏡像倉庫
- 07.docker私有鏡像倉庫harbor
- 08.docker網絡
- 09.docker項目實戰01
- 10.docker項目實戰02
- 11.docker componse
- 12.docker-compose常用命令
- 13.docker compose 案例
- 14.docker swarm集群
- 15.docker swarm常用命令
- 16.docker swarm 案例
- 17.volume
- 18.network
- 19.idea中部署項目到docker
- 20.docker目錄方式掛載sqlite
- 21.docker常用命令補充
- 22.nginx容器代理靜態文件403解決
- 23.docker集群管理平臺
- k8s
- 01.Kubernetes介紹
- 02.K8s基本概念
- 03.K8s架構圖
- 04.Minikube單節點環境搭建
- 05.kubeadm集群安裝1.14.0
- 06.虛擬機靜態網絡配置
- 07.kubeadm高可用集群安裝1.14.0
- 08 高可用VIP配置(keepalived+haproxy)
- 09.高可用免密登錄
- 10.kubeadm init流程
- 11.k8s體驗
- 12.網絡插件
- 13.Ingress
- 14.Ingress分類
- 15.Dashboard
- 16.存儲
- 01.Volumes
- 02.nfs
- 03.PV PVC
- 04.StorageClass
- 17.基礎組件
- 01.Pod
- 02.Service
- 03.ReplicaSet(RS)
- 04.Deployment
- 06.Namespace
- 02.DaemonSet
- 03.StatefulSet
- 04.ReplicationController(RC)
- 06.Job
- 09.PetSet
- 10.StatefulSets
- 11.Federation
- 12.Secret
- 05.Resources
- 13.UserAccount/ServiceAccount
- 14.RBAC
- 18.核心組件
- Master組件
- 01.kube-apiserver
- 02.etcd
- 03.kube-controller-manager
- 04.cloud-controller-manager
- 05.kube-scheduler
- 06.DNS
- Node組件
- 01.kubelet
- 02.kube-proxy
- 03.docker
- 04.RKT
- 05.supervisord
- 06.fluentd
- kubectl
- 19.K8S服務更新部署
- 20.CI/CD
- 01.java安裝
- 02.maven安裝
- 03.gitlab安裝
- 04.git安裝
- 05.jenkins安裝
- 06.k8s集群
- 07.DockerHub
- 08.實戰
- 21.日志
- 01.不同組件日志
- 02.LogPilot+ES+Kibana
- 22.監控
- 23.k8s部署ocp項目[mysql]
- 01.ocp介紹
- 02.環境準備
- 03.鏡像準備
- 04.部署說明
- 05.eureka-server
- 06.mysql
- 07.redis
- 08.auth-server
- 09.user-center
- 10.new-api-gateway
- 11.back-center
- 飛致云kubeoperator
- 01.kubeoperator介紹
- 02.kubeoperator安裝
- 飛致云DataEase
- 項目介紹
- 系統架構
- 安裝部署
- 在線安裝
- 離線安裝
- 用戶手冊
- 通用功能
- 數據源
- 數據集
- 視圖
- 儀表板
- 系統管理
- 用戶管理
- 飛致云JumpServer
- TIDB
- 網絡
- 交換機
- ISO/OSI協議模型詳解
- 交換CCNP
- RSTP快速生成樹協議
- MST多生成樹協議
- 以太網信道【應用廣泛】
- 廣播和多播抑制
- 多層交換
- ARP地址解析協議抑制
- VLAN間路由
- 熱備份路由協議HSRP【思科私有】
- 虛擬路由器冗余協議VRRP
- linux
- 01.時間同步
- linux時間不能同步
- Linux掛載磁盤
- 安裝ftp
- linux環境ftp賬號
- HTTP狀態碼
- 寶塔
- Centos安裝vsftp
- nginx ssl 配置
- datax
- 1.geom類型遷移擴展
- python安裝
- 消息中間件
- 1.RocketMQ
- 1.RocketMQ單機環境安裝
- 前端
- node踩坑之npm
- 數據庫
- Mysql安裝
- ClickHouse
- OceanBase數據庫
- OceanBase介紹
- OceanBase數據庫整體架構
- 快速入門
- 資源準備
- 安裝 OBD部署 OceanBase 數據庫
- 基本操作
- 數據庫操作
- 表操作
- 索引操作
- 插入數據
- 刪除數據
- 更新數據
- 提交事務
- 回滾事務
- 安裝部署
- 使用 RPM 包安裝 OceanBase 數據庫
- 使用源碼構建 OceanBase 數據庫
- 設置無密碼 SSH 登錄
- 配置時鐘源
- 數據分布
- 集群管理
- 租戶與資源管理
- 數據分布1
- 數據副本與服務
- 數據均衡
- 數據模型
- 多租戶架構
- 系統租戶
- 普通租戶
- 表格和表組
- 二級索引
- 無主鍵表
- 視圖
- 高可用
- 高可用方案
- 部署模式
- redo 日志管理控制
- 事務管理
- 隔離級別
- 并發控制
- 全局時間戳服務
- 本地事務
- 分布式事務
- 分布式查詢
- 存儲架構
- LSM Tree 架構
- 內存表 MemTable
- 塊存儲 SSTable
- 轉儲和合并
- 緩存機制
- 讀寫流程
- DDL
- SQL 引擎
- SQL 請求執行流程
- 查詢改寫
- 基于規則的查詢改寫
- 基于代價的查詢改寫
- 查詢優化
- 訪問路徑
- 基于規則的路徑選擇
- 基于代價的路徑選擇
- 聯接算法
- 聯接算法
- 聯接順序
- SQL 執行計劃
- 執行計劃算子
- TABLE SCAN
- TABLE LOOKUP
- JOIN
- COUNT
- GROUP BY
- WINDOW FUNCTION
- SUBPLAN FILTER
- DISTINCT
- SEQUENCE
- MATERIAL
- SORT
- LIMIT
- FOR UPDATE
- SELECT INTO
- SUBPLAN SCAN
- UNION
- INTERSECT
- EXCEPT/MINUS
- INSERT
- DELETE
- UPDATE
- MERGE
- EXCHANGE
- GI
- 執行計劃緩存
- 快速參數化
- 實時執行計劃展示
- 分布式執行計劃
- 分布式執行和并行查詢
- 分布式計劃的生成
- 分布式執行計劃調度
- 分布式執行計劃管理
- 并行查詢的執行
- 并行查詢的參數調優
- 備份與恢復
- 備份架構
- 恢復架構
- Backup Set
- Archive Log Round
- 管理員指南
- 數據庫基礎組件介紹
- 數據庫管理工具介紹
- OceanBase 客戶端
- MySQL 客戶端
- 數據庫基礎管理
- OceanBase 集群管理
- 集群參數管理
- 查詢集群參數
- 修改集群參數
- Zone 管理
- 增加或刪除 Zone
- 啟動或停止 Zone
- 修改 Zone
- OBServer 管理
- 查看 OBServer 狀態
- 停止 OBServer
- 啟動 OBServer
- 管理 OBServer 節點狀態
- 資源管理
- 創建資源單元
- 查看資源單元
- 修改資源單元
- 刪除資源單元
- 創建資源池
- 查看資源配置
- 修改資源池
- 刪除資源池
- 租戶管理
- 創建用戶租戶
- 新建租戶
- 查看租戶
- 修改租戶
- 刪除租戶
- 查看租戶會話
- 終止租戶會話
- 租戶管理變量
- 內存管理
- OceanBase 內存結構
- OceanBase 數據庫內存上限
- 系統內部內存管理
- 租戶內部內存管理
- 執行計劃緩存
- 常見內存問題
- 數據庫對象管理
- 管理表
- 關于表
- 創建表
- 定義自增列
- 定義列的約束類型
- 查看表的定義
- 更改表
- 清空表
- 刪除表
- 管理表組
- 關于表組
- 表組管理命令
- 管理索引
- 關于索引
- 創建索引
- 查看索引
- 刪除索引
- 視圖和同義詞管理
- 管理視圖
- 管理同義詞
- 數據分布和鏈路管理
- 分區表和分區索引管理
- 關于分區
- 分區策略
- 創建分區表
- 一級分區表
- 二級分區表
- 維護分區表
- 一級分區表
- 二級分區表
- 分區裁剪
- 分區命名與查詢
- 在分區表上建立索引
- 局部索引
- 全局索引
- 使用索引
- 副本管理
- 表級副本的使用
- Locality 管理
- 修改租戶的 Locality
- 事務管理
- 提交事務
- 回滾事務
- 事務隔離級別
- 用戶權限管理
- 創建用戶
- 修改用戶權限
- 查看白名單
- 鎖定和解鎖用戶
- 刪除用戶
- 數據高可用
- 回收站管理
- 回收站支持的對象
- 數據庫、表和索引級回收站
- 租戶級回收站
- 物理備份與恢復管理
- 部署 NFS
- 備份數據
- 通過命令行備份
- 查看備份進度
- 停止備份
- 刪除過期的備份
- 清理備份數據
- 取消清理備份數據
- 恢復數據
- 執行恢復
- 查看恢復進度和結果
- 備份維護
- 開發者指南
- 關于OceanBase數據庫
- OceanBase 集群簡介
- OceanBase 租戶簡介
- MySQL 租戶數據庫對象
- MySQL 客戶端
- OceanBase 客戶端(obclient)
- 關于結構化查詢語言
- Java 數據庫連接驅動(JDBC)
- 連接OceanBase數據庫
- 通過 MySQL 客戶端連接 OceanBase 租戶
- 通過 obclient 連接 OceanBase 租戶
- 創建 OceanBase 示例數據庫 TPCC
- 通過 obclient 探索 OceanBase MySQL 租戶
- 查詢表數據
- 關于查詢語句
- 查詢表里符合特定搜索條件的數據
- 對查詢的結果進行排序
- 從多個表里查詢數據
- 在查詢中使用操作符和函數
- 查看查詢執行計劃
- 在查詢中使用 SQL Hint
- 關于查詢超時設計
- 關于 DML 語句和事務
- 關于 DML 語句
- 關于 INSERT 語句
- 關于 UPDATE 語句
- 關于 DELETE 語句
- 關于 REPLACE INTO 語句
- 關于事務控制語句
- 提交事務
- 回滾事務
- 事務保存點
- 關于事務超時
- 創建和管理數據庫對象
- 關于 DDL 語句
- 創建數據庫
- 創建和管理表
- 關于 SQL 數據類型
- 創建表
- 關于自增列
- 關于列的約束類型
- 關于表的索引
- 閃回被刪除的表
- 創建和管理分區表
- 分區路由
- 分區策略
- 分區表的索引
- 分區表使用建議
- 創建和管理表組
- 關于表組
- 創建表時指定表組
- 查看表組信息
- 向表組中增加表
- 刪除表組
- 創建和管理視圖
- 創建視圖
- 修改視圖
- 刪除視圖
- 向 OceanBase 遷移數據
- DataX
- 不同數據源的 DataX 讀寫插件示例
- OceanBase 數據加載技術
- 附錄
- OceanBase 常用參數和變量
- OceanBase 常用 SQL
- SQL參考
- 基本元素
- 運算符
- 函數
- 函數
- 聚集函數
- 分析函數
- 信息函數
- 其它函數
- 查詢和子查詢
- 連接
- 集合
- SQL語句
- 通用語法
- ALTER DATABASE
- ALTER OUTLINE
- ALTER RESOURCE POOL
- ALTER RESOURCE UNIT
- ALTER SYSTEM
- ALTER TABLE
- ALTER TABLEGROUP
- ALTER TENANT
- ALTER USER
- CREATE DATABASE
- CREATE INDEX
- CREATE OUTLINE
- CREATE RESOURCE POOL
- CREATE RESOURCE UNIT
- CREATE RESTORE POINT
- CREATE SYNONYM
- CREATE TABLE
- CREATE TABLEGROUP
- CREATE TENANT
- CREATE USER
- CREATE VIEW
- DELETE
- DROP DATABASE
- DROP INDEX
- DROP OUTLINE
- DROP RESOURCE POOL
- DROP RESOURCE UNIT
- DROP RESTORE POINT
- DROP TABLE
- DROP TABLEGROUP
- DROP TENANT
- DROP SYNONYM
- DROP USER
- DROP VIEW
- EXPLAIN
- FLASHBACK DATABASE
- FLASHBACK TABLE
- FLASHBACK TENANT
- GRANT
- INSERT
- KILL
- PURGE DATABASE
- PURGE INDEX
- PURGE RECYCLEBIN
- PURGE TABLE
- PURGE TENANT
- RENAME TABLE
- RENAME USER
- REPLACE
- REVOKE
- SAVEPOINT
- SCHEMA
- SELECT
- SESSION
- SET PASSWORD
- SHOW GRANTS
- SHOW RECYCLEBIN
- TRANSACTION
- TRUNCATE TABLE
- UPDATE
- SQL調優指南
- SQL請求執行流程
- SQL 執行計劃
- SQL 執行計劃簡介
- 執行計劃算子
- TABLE SCAN
- TABLE LOOKUP
- JOIN
- COUNT
- GROUP BY
- WINDOW FUNCTION
- SUBPLAN FILTER
- DISTINCT
- SEQUENCE
- MATERIAL
- SORT
- LIMIT
- FOR UPDATE
- SELECT INTO
- SUBPLAN SCAN
- UNION
- INTERSECT
- EXCEPT/MINUS
- INSERT
- DELETE
- UPDATE
- MERGE
- EXCHANGE
- GI
- 執行計劃緩存
- 快速參數化
- 實時執行計劃展示
- 分布式執行計劃
- 分布式執行和并行查詢
- 分布式計劃的生成
- 分布式執行計劃調度
- 分布式執行計劃管理
- 并行查詢的執行
- 并行查詢的參數調優
- 參考指南
- 系統視圖
- 概述
- 字典視圖
- mysql.help_topic
- mysql.help_category
- mysql.help_keyword
- mysql.help_relation
- mysql.db
- mysql.proc
- mysql.time_zone
- mysql.time_zone_name
- mysql.time_zone_transition
- mysql.time_zone_transition_type
- mysql.user
- information_schema.CHARACTER_SETS
- information_schema.COLLATIONS
- information_schema.COLLATION_CHARACTER_SET_APPLICABILITY
- information_schema.COLUMNS
- information_schema.DBA_OUTLINES
- information_schema.ENGINES
- information_schema.GLOBAL_STATUS
- information_schema.GLOBAL_VARIABLES
- information_schema.KEY_COLUMN_USAGE
- information_schema.PARAMETERS
- information_schema.PARTITIONS
- information_schema.PROCESSLIST
- information_schema.REFERENTIAL_CONSTRAINTS
- information_schema.ROUTINES
- information_schema.SCHEMATA
- information_schema.SCHEMA_PRIVILEGES
- information_schema.SESSION_STATUS
- information_schema.SESSION_VARIABLES
- information_schema.STATISTICS
- information_schema.TABLES
- information_schema.TABLE_CONSTRAINTS
- information_schema.TABLE_PRIVILEGES
- information_schema.USER_PRIVILEGES
- information_schema.USER_RECYCLEBIN
- information_schema.VIEWS
- oceanbase.CDB_OB_BACKUP_ARCHIVELOG_SUMMARY
- oceanbase.CDB_OB_BACKUP_JOB_DETAILS
- oceanbase.CDB_OB_BACKUP_SET_DETAILS
- oceanbase.CDB_OB_BACKUP_PROGRESS
- oceanbase.CDB_OB_BACKUP_SET_EXPIRED
- oceanbase.CDB_OB_BACKUP_ARCHIVELOG_PROGRESS
- oceanbase.CDB_OB_BACKUP_CLEAN_HISTORY
- oceanbase.CDB_OB_BACKUP_TASK_CLEAN_HISTORY
- oceanbase.CDB_OB_RESTORE_PROGRESS
- oceanbase.CDB_OB_RESTORE_HISTORY
- oceanbase.CDB_CKPT_HISTORY
- oceanbase.CDB_OB_BACKUP_VALIDATION_JOB
- oceanbase.CDB_OB_BACKUP_VALIDATION_JOB_HISTORY
- oceanbase.CDB_OB_TENANT_BACKUP_VALIDATION_TASK
- oceanbase.CDB_OB_BACKUP_VALIDATION_TASK_HISTORY
- oceanbase.CDB_OB_BACKUP_BACKUP_ARCHIVELOG_SUMMARY
- oceanbase.CDB_OB_BACKUP_BACKUPSET_TASK_HISTORY
- oceanbase.CDB_OB_BACKUP_BACKUPSET_TASK
- oceanbase.CDB_OB_BACKUP_BACKUPSET_JOB_HISTORY
- oceanbase.CDB_OB_BACKUP_BACKUPSET_JOB
- oceanbase.CDB_OB_BACKUP_SET_OBSOLETE
- 性能視圖
- gv$plan_cache_stat
- gv$plan_cache_plan_stat
- gv$session_event
- gv$session_wait
- gv$session_wait_history
- gv$system_event
- gv$sesstat
- gv$sysstat
- gv$sql_audit
- gv$latch
- gv$memory
- gv$memstore
- gv$memstore_info
- gv$plan_cache_plan_explain
- gv$obrpc_outgoing
- gv$obrpc_incoming
- gv$sql
- gv$sql_plan_monitor
- gv$outline
- gv$concurrent_limit_sql
- gv$sql_plan_statistics
- gv$server_memstore
- gv$unit_load_balance_event_history
- gv$tenant
- gv$database
- gv$table
- gv$unit
- gv$partition
- gv$lock_wait_stat
- gv$session_longops
- gv$tenant_memstore_allocator_info
- gv$minor_merge_info
- gv$tenant_px_worker_stat
- gv$partition_audit
- gv$ps_stat
- gv$ps_item_info
- gv$sql_workarea
- gv$sql_workarea_histogram
- gv$ob_sql_workarea_memory_info
- gv$server_schema_info
- gv$merge_info
- gv$lock
- gv$sstable
- gv$ob_trans_table_status
- v$statname
- v$event_name
- v$session_event
- v$session_wait
- v$session_wait_history
- v$sesstat
- v$sysstat
- v$system_event
- v$memory
- v$memstore
- v$memstore_info
- v$plan_cache_stat
- v$plan_cache_plan_stat
- v$plan_cache_plan_explain
- v$sql_audit
- v$obrpc_outgoing
- v$obrpc_incoming
- v$sql
- v$sql_monitor
- v$sql_plan_monitor
- v$sql_plan_statistics
- v$unit
- v$partition
- v$lock_wait_stat
- v$session_longops
- v$latch
- v$tenant_memstore_allocator_info
- v$tenant_px_worker_stat
- v$partition_audit
- v$ob_cluster
- v$ob_standby_status
- v$ob_cluster_stats
- v$ob_cluster_event_history
- v$ps_stat
- v$ps_item_info
- v$sql_workarea
- v$sql_workarea_active
- v$sql_workarea_histogram
- v$ob_sql_workarea_memory_info
- v$ob_timestamp_service
- v$server_schema_info
- v$merge_info
- v$lock
- v$sql_monitor_statname
- v$restore_point
- v$ob_cluster_failover_info
- v$encrypted_tables
- v$encrypted_tablespaces
- v$sstable
- v$ob_trans_table_status
- 系統變量
- 系統變量概述
- auto_increment_increment
- auto_increment_offset
- autocommit
- character_set_client
- character_set_connection
- character_set_database
- character_set_results
- character_set_server
- character_set_system
- collation_connection
- collation_database
- collation_server
- interactive_timeout
- last_insert_id
- max_allowed_packet
- sql_mode
- time_zone
- tx_isolation
- version_comment
- wait_timeout
- binlog_row_image
- character_set_filesystem
- connect_timeout
- datadir
- debug_sync
- div_precision_increment
- explicit_defaults_for_timestamp
- group_concat_max_len
- identity
- lower_case_table_names
- net_read_timeout
- net_write_timeout
- read_only
- sql_auto_is_null
- sql_select_limit
- timestamp
- tx_read_only
- version
- sql_warnings
- max_user_connections
- init_connect
- license
- net_buffer_length
- system_time_zone
- query_cache_size
- query_cache_type
- sql_quote_show_create
- max_sp_recursion_depth
- sql_safe_updates
- ob_proxy_partition_hit
- ob_log_level
- ob_max_parallel_degree
- ob_query_timeout
- ob_read_consistency
- ob_enable_transformation
- ob_trx_timeout
- ob_enable_plan_cache
- ob_enable_index_direct_select
- ob_proxy_set_trx_executed
- ob_enable_aggregation_pushdown
- ob_last_schema_version
- ob_global_debug_sync
- ob_proxy_global_variables_version
- ob_enable_trace_log
- ob_enable_hash_group_by
- ob_enable_blk_nestedloop_join
- ob_bnl_join_cache_size
- ob_org_cluster_id
- ob_plan_cache_percentage
- ob_plan_cache_evict_high_percentage
- ob_plan_cache_evict_low_percentage
- recyclebin
- ob_capability_flag
- ob_stmt_parallel_degree
- is_result_accurate
- error_on_overlap_time
- ob_compatibility_mode
- ob_create_table_strict_mode
- ob_sql_work_area_percentage
- ob_route_policy
- ob_enable_transmission_checksum
- foreign_key_checks
- ob_enable_truncate_flashback
- ob_tcp_invited_nodes
- sql_throttle_current_priority
- sql_throttle_priority
- sql_throttle_rt
- sql_throttle_network
- auto_increment_cache_size
- ob_enable_jit
- ob_timestamp_service
- plugin_dir
- undo_retention
- ob_sql_audit_percentage
- ob_enable_sql_audit
- optimizer_use_sql_plan_baselines
- optimizer_capture_sql_plan_baselines
- parallel_max_servers
- parallel_servers_target
- ob_trx_idle_timeout
- block_encryption_mode
- ob_reserved_meta_memory_percentage
- ob_check_sys_variable
- tracefile_identifier
- transaction_isolation
- ob_trx_lock_timeout
- validate_password_check_user_name
- validate_password_length
- validate_password_mixed_case_count
- validate_password_number_count
- validate_password_policy
- validate_password_special_char_count
- default_password_lifetime
- ob_trace_info
- secure_file_priv
- ob_pl_block_timeout
- performance_schema
- transaction_read_only
- resource_manager_plan
- 系統配置項
- 系統配置項概述
- auto_leader_switch_interval
- auto_delete_expired_backup
- autoinc_cache_refresh_interval
- audit_sys_operations
- audit_trail
- balancer_idle_time
- balancer_log_interval
- balancer_timeout_check_interval
- balancer_task_timeout
- balancer_tolerance_percentage
- balancer_emergency_percentage
- balance_blacklist_failure_threshold
- balance_blacklist_retry_interval
- backup_concurrency
- backup_dest
- backup_net_limit
- backup_recovery_window
- backup_region
- builtin_db_data_verify_cycle
- bf_cache_miss_count_threshold
- bf_cache_priority
- cache_wash_threshold
- clog_cache_priority
- clog_sync_time_warn_threshold
- clog_disk_usage_limit_percentage
- clog_transport_compress_all
- clog_transport_compress_func
- clog_persistence_compress_func
- clog_max_unconfirmed_log_count
- cluster
- cluster_id
- cpu_count
- cpu_quota_concurrency
- cpu_reserved
- config_additional_dir
- data_copy_concurrency
- data_dir
- datafile_disk_percentage
- dtl_buffer_size
- datafile_size
- debug_sync_timeout
- default_compress_func
- default_compress
- default_progressive_merge_num
- default_row_format
- devname
- data_disk_usage_limit_percentage
- disk_io_thread_count
- dead_socket_detection_timeout
- enable_clog_persistence_compress
- election_cpu_quota
- enable_one_phase_commit
- enable_sys_unit_standalone
- enable_pg
- enable_smooth_leader_switch
- election_blacklist_interval
- enable_election_group
- enable_auto_leader_switch
- enable_global_freeze_trigger
- enable_manual_merge
- enable_merge_by_turn
- enable_perf_event
- enable_rebalance
- enable_record_trace_log
- enable_record_trace_id
- enable_early_lock_release
- enable_rereplication
- enable_rich_error_msg
- enable_rootservice_standalone
- enable_sql_audit
- enable_sql_operator_dump
- enable_async_syslog
- enable_syslog_recycle
- enable_syslog_wf
- enable_upgrade_mode
- enable_separate_sys_clog
- enable_ddl
- enable_major_freeze
- enable_rebuild_on_purpose
- enable_log_archive
- enable_monotonic_weak_read
- external_kms_info
- freeze_trigger_percentage
- flush_log_at_trx_commit
- fuse_row_cache_priority
- force_refresh_location_cache_interval
- force_refresh_location_cache_threshold
- get_leader_candidate_rpc_timeout
- global_major_freeze_residual_memory
- global_write_halt_residual_memory
- ignore_replay_checksum_error
- global_index_build_single_replica_timeout
- high_priority_net_thread_count
- ignore_replica_checksum_error
- ignore_replay_checksum_error
- index_cache_priority
- index_clog_cache_priority
- index_info_block_cache_priority
- internal_sql_execute_timeout
- large_query_worker_percentage
- large_query_threshold
- leak_mod_to_check
- lease_time
- location_cache_cpu_quota
- location_cache_expire_time
- location_cache_priority
- location_cache_refresh_min_interval
- location_fetch_concurrency
- location_refresh_thread_count
- log_archive_checkpoint_interval
- log_archive_concurrency
- log_restore_concurrency
- major_freeze_duty_time
- max_kept_major_version_number
- max_string_print_length
- max_syslog_file_count
- merge_stat_sampling_ratio
- major_compact_trigger
- memory_chunk_cache_size
- memory_limit
- memory_limit_percentage
- memory_reserved
- merge_thread_count
- merger_check_interval
- merger_completion_percentage
- merger_switch_leader_duration_time
- merger_warm_up_duration_time
- max_px_worker_count
- migration_disable_time
- min_observer_version
- minor_deferred_gc_time
- minor_freeze_times
- minor_warm_up_duration_time
- mysql_port
- minor_merge_concurrency
- multiblock_read_gap_size
- multiblock_read_size
- micro_block_merge_verify_level
- migrate_concurrency
- minor_compact_trigger
- memstore_limit_percentage
- net_thread_count
- obconfig_url
- ob_enable_batched_multi_statement
- partition_table_check_interval
- partition_table_scan_batch_count
- plan_cache_evict_interval
- px_task_size
- px_workers_per_cpu_quota
- replica_safe_remove_time
- resource_hard_limit
- resource_soft_limit
- rootservice_async_task_queue_size
- rootservice_async_task_thread_count
- rootservice_list
- rootservice_ready_check_interval
- row_compaction_update_limit
- row_purge_thread_count
- rpc_port
- rpc_timeout
- restore_concurrency
- rootservice_memory_limit
- rebuild_replica_data_lag_threshold
- schema_history_expire_time
- ssl_client_authentication
- server_check_interval
- server_data_copy_in_concurrency
- server_data_copy_out_concurrency
- server_permanent_offline_time
- stack_size
- server_balance_critical_disk_waterlevel
- server_balance_disk_tolerance_percent
- system_memory
- server_balance_cpu_mem_tolerance_percent
- server_cpu_quota_max
- server_cpu_quota_min
- sql_audit_memory_limit
- sys_bkgd_io_high_percentage
- sys_bkgd_io_low_percentage
- sys_bkgd_io_timeout
- sys_bkgd_net_percentage
- sys_bkgd_migration_change_member_list_timeout
- sys_bkgd_migration_retry_num
- syslog_level
- switchover_process_thread_count
- system_cpu_quota
- sys_cpu_limit_trigger
- syslog_io_bandwidth_limit
- tablet_size
- tableapi_transport_compress_func
- tenant_task_queue_size
- tenant_groups
- trace_log_slow_query_watermark
- trace_log_sampling_interval
- trx_2pc_retry_interval
- trx_force_kill_threshold
- tde_method
- token_reserved_percentage
- unit_balance_resource_weight
- user_block_cache_priority
- user_row_cache_priority
- user_tab_col_stat_cache_priority
- user_iort_up_percentage
- use_large_pages
- virtual_table_location_cache_expire_time
- workers_per_cpu_quota
- wait_leader_batch_count
- writing_throttling_maximum_duration
- writing_throttling_trigger_percentage
- weak_read_version_refresh_interval
- workarea_size_policy
- zone
- zone_merge_concurrency
- zone_merge_order
- zone_merge_timeout
- ob_ssl_invited_common_names
- ssl_external_kms_info
- ob_event_history_recycle_interval
- backup_log_archive_checkpoint_interval
- plsql_ccflags
- plsql_code_type
- plsql_debug
- plsql_optimize_level
- plsql_v2_compatibility
- plsql_warnings
- recyclebin_object_expire_time
- log_archive_batch_buffer_limit
- clog_disk_utilization_threshold
- backup_backup_archive_log_batch_count
- backup_backup_archivelog_retry_interval
- backup_backupset_batch_count
- backup_backupset_retry_interval
- open_cursors
- fast_recovery_concurrency
- 預留關鍵字
- 部署實踐
- 設置無密碼 SSH 登錄
- 單機安裝
- 本地安裝
- 分布式安裝
- 創建租戶
- OceanBaseDeploy(OBD)常用命令
- 大數據
- 數據倉庫分層
- 數據倉庫分層實踐
- hive安裝
- hive命令
- hadoop安裝
- jdk安裝
- 應龍inlong
- 網關
- apisix
- apisix2.7源碼安裝
- apisix rpm2.6安裝
- apisix-dashboard2.7 rpm安裝
- apisix-dashboard使用
- apisix-dashboard進階