DOCSUP-3121: Update the SHOW DATABASES and SHOW TABLES descriptions #16115
Conversation
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Update descriptions of show databases and show tables.
robot-clickhouse
added
the
pr-documentation
Update 'identical query'.
BayoNet
reviewed
Oct 20, 2020
| Syntax: | ||
|
|
||
| ```sql | ||
| SHOW DATABASES [LIKE '<pattern>'] [ILIKE '<pattern>'] [NOT LIKE '<pattern>'] [LIMIT <N>] [INTO OUTFILE filename] [FORMAT format] |
There was a problem hiding this comment.
Suggested change
| SHOW DATABASES [LIKE '<pattern>'] [ILIKE '<pattern>'] [NOT LIKE '<pattern>'] [LIMIT <N>] [INTO OUTFILE filename] [FORMAT format] | |
| SHOW DATABASES [LIKE|ILIKE|NOT LIKE '<pattern>'] [LIMIT <N>] [INTO OUTFILE filename] [FORMAT format] |
BayoNet
reviewed
Oct 20, 2020
| This statement is identical to the query: | ||
|
|
||
| ```sql | ||
| SELECT name FROM system.databases [WHERE name LIKE '<pattern>'] [WHERE name ILIKE '<pattern>'] [WHERE name NOT LIKE '<pattern>'] [LIMIT <N>] [INTO OUTFILE filename] [FORMAT format] |
There was a problem hiding this comment.
Suggested change
| SELECT name FROM system.databases [WHERE name LIKE '<pattern>'] [WHERE name ILIKE '<pattern>'] [WHERE name NOT LIKE '<pattern>'] [LIMIT <N>] [INTO OUTFILE filename] [FORMAT format] | |
| SELECT name FROM system.databases [WHERE name LIKE|ILIKE|NOT LIKE '<pattern>'][LIMIT <N>] [INTO OUTFILE filename] [FORMAT format] |
BayoNet
reviewed
Oct 20, 2020
| SELECT name FROM system.databases [WHERE name LIKE '<pattern>'] [WHERE name ILIKE '<pattern>'] [WHERE name NOT LIKE '<pattern>'] [LIMIT <N>] [INTO OUTFILE filename] [FORMAT format] | ||
| ``` | ||
|
|
||
| ### SHOW DATABASES LIKE {#show-databases-like} |
There was a problem hiding this comment.
I think it's better to place all the examples under the header ### Examples.
Each example doesn't need the header. You can preface examples with a description of what the example does. For example, "Getting database names, containing the symbol sequence de in their names."
BayoNet
reviewed
Oct 20, 2020
|
|
||
| ### SHOW DATABASES LIKE {#show-databases-like} | ||
|
|
||
| Syntax: |
There was a problem hiding this comment.
This is not syntax, this is query.
Внес поправки согласно комментариям.
BayoNet
reviewed
Oct 21, 2020
| └─────────┘ | ||
| ``` | ||
|
|
||
| Getting database names, containing the case insensitive symbols sequence 'de' in their names: |
There was a problem hiding this comment.
Suggested change
| Getting database names, containing the case insensitive symbols sequence 'de' in their names: | |
| Getting database names, containing symbols sequence 'de' in their names, in the case insensitive manner: |
Внес поправки и перевел на русский язык.
BayoNet
reviewed
Oct 22, 2020
| └─────────┘ | ||
| ``` | ||
|
|
||
| Получение списка баз данных, имена которых нечувствительные к регистру и содержащие последовательность символов 'de': |
There was a problem hiding this comment.
Suggested change
| Получение списка баз данных, имена которых нечувствительные к регистру и содержащие последовательность символов 'de': | |
| Получение списка баз данных, имена которых содержат последовательность символов 'de' независимо от регистра: |
BayoNet
reviewed
Oct 22, 2020
| └────────────────────────────────┘ | ||
| ``` | ||
|
|
||
| Получение первых 2 строк из списка имен баз данных: |
There was a problem hiding this comment.
Suggested change
| Получение первых 2 строк из списка имен баз данных: | |
| Получение первых двух строк из списка имен баз данных: |
BayoNet
reviewed
Oct 22, 2020
| └──────────────────┘ | ||
| ``` | ||
|
|
||
| Получение списка таблиц, имена которых нечувствительные к регистру и содержащие последовательность символов 'user': |
There was a problem hiding this comment.
Suggested change
| Получение списка таблиц, имена которых нечувствительные к регистру и содержащие последовательность символов 'user': | |
| Получение списка таблиц, имена которых содержат последовательность символов 'user' без учёта регистра: |
Внес мелкие поправки.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Add this suggestion to a batch that can be applied as a single commit.
This suggestion is invalid because no changes were made to the code.
Suggestions cannot be applied while the pull request is closed.
Suggestions cannot be applied while viewing a subset of changes.
Only one suggestion per line can be applied in a batch.
Add this suggestion to a batch that can be applied as a single commit.
Applying suggestions on deleted lines is not supported.
You must change the existing code in this line in order to create a valid suggestion.
Outdated suggestions cannot be applied.
This suggestion has been applied or marked resolved.
Suggestions cannot be applied from pending reviews.
Suggestions cannot be applied on multi-line comments.
Suggestions cannot be applied while the pull request is queued to merge.
Suggestion cannot be applied right now. Please check back later.
I hereby agree to the terms of the CLA available at: https://yandex.ru/legal/cla/?lang=en
Changelog category: