You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by lu...@apache.org on 2024/04/14 03:41:21 UTC
(doris-website) branch master updated: [doc] function quote update (#531)
This is an automated email from the ASF dual-hosted git repository.
luzhijing pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new 726fb8b412 [doc] function quote update (#531)
726fb8b412 is described below
commit 726fb8b412c585e1a2ea22cb6f8a54344a5cc806
Author: Uniqueyou <13...@users.noreply.github.com>
AuthorDate: Sun Apr 14 11:41:16 2024 +0800
[doc] function quote update (#531)
---
.../sql-functions/string-functions/quote.md | 45 ++++++++++++++++++++++
.../sql-functions/string-functions/quote.md | 45 ++++++++++++++++++++++
sidebars.json | 1 +
3 files changed, 91 insertions(+)
diff --git a/docs/sql-manual/sql-functions/string-functions/quote.md b/docs/sql-manual/sql-functions/string-functions/quote.md
new file mode 100644
index 0000000000..e36c88548a
--- /dev/null
+++ b/docs/sql-manual/sql-functions/string-functions/quote.md
@@ -0,0 +1,45 @@
+---
+{
+ "title": "QUOTE",
+ "language": "en"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+ http://www.apache.org/licenses/LICENSE-2.0
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## quote
+### description
+#### Syntax
+
+`VARCHAR quote(VARCHAR str)`
+
+
+Output all the strings in the argument as is and wrap them with ''
+
+### example
+
+```
+mysql> select quote('hello world!\\t');
++-------------------------+
+| quote('hello world!\t') |
++-------------------------+
+| 'hello world!\t' |
++-------------------------+
+```
+### keywords
+ QUOTE
\ No newline at end of file
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/quote.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/quote.md
new file mode 100644
index 0000000000..9d9d1194de
--- /dev/null
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/quote.md
@@ -0,0 +1,45 @@
+---
+{
+ "title": "QUOTE",
+ "language": "zh-CN"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+ http://www.apache.org/licenses/LICENSE-2.0
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## quote
+### description
+#### Syntax
+
+`VARCHAR quote(VARCHAR str)`
+
+
+将参数中所有的字符串按原样输出,并用''套起来
+
+### example
+
+```
+mysql> select quote('hello world!\\t');
++-------------------------+
+| quote('hello world!\t') |
++-------------------------+
+| 'hello world!\t' |
++-------------------------+
+```
+### keywords
+ QUOTE
\ No newline at end of file
diff --git a/sidebars.json b/sidebars.json
index 8cb3a1cbbd..49c9fc7a8f 100644
--- a/sidebars.json
+++ b/sidebars.json
@@ -528,6 +528,7 @@
"sql-manual/sql-functions/string-functions/strleft",
"sql-manual/sql-functions/string-functions/strcmp",
"sql-manual/sql-functions/string-functions/strright",
+ "sql-manual/sql-functions/string-functions/quote",
"sql-manual/sql-functions/string-functions/split-part",
"sql-manual/sql-functions/string-functions/split-by-string",
"sql-manual/sql-functions/string-functions/substring-index",
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org