PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/parenthesized-query-expressions.html
parenthesized_query_expression: ( query_expression [order_by_clause] [limit_clause] ) [order_by_clause] [limit_clause] [into_clause] query_expression: query_block [set_op query_block [set_op query_block ...]] [order_by_clause] [limit_clause] ...
https://dev.mysql.com/doc/refman/8.0/en/string-comparison-functions.html
This differs from comparisons performed with the = operator, for which the significance of trailing spaces in nonbinary strings (CHAR, VARCHAR, and TEXT values) depends on the pad attribute of the collation used for the comparison. Table 14.13 ...
https://dev.mysql.com/doc/refman/8.0/en/set-operations.html
As of MySQL 8.0.20, these two UNION variants containing INTO are deprecated; you should expect support for them to be removed in a future version of MySQL: In the trailing query block of a query expression, use of INTO before FROM produces a warning. UNION SELECT * INTO OUTFILE 'file_name' FROM table_name; In a parenthesized trailing block of a query expression, use of INTO (regardless of its position relative to FROM) produces a ... Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set ...
https://dev.mysql.com/doc/refman/8.0/en/show-collation.html
This attribute affects whether trailing spaces are significant in string comparisons; for more information, see Trailing Space Handling in Comparisons. SHOW COLLATION [LIKE 'pattern' | WHERE expr] This statement lists collations supported by the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-collations-table.html
This attribute affects whether trailing spaces are significant in string comparisons; see Trailing Space Handling in Comparisons. The COLLATIONS table provides information about collations for each character set. CHARACTER_SET_NAME The name of the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html
For UNION statements, these two variants containing INTO are deprecated as of MySQL 8.0.20: In the trailing query block of a query expression, use of INTO before FROM. In a parenthesized trailing block of a query expression, use of INTO, regardless ... This section summarizes what has been added to, deprecated in, and removed from MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/myisampack.html
end-space The number of columns that have a lot of trailing spaces. In this case, each value contains a count for the number of trailing spaces. When the table is used later, the server reads into memory the information needed to decompress columns.
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html
PAD_CHAR_TO_FULL_LENGTH By default, trailing spaces are trimmed from CHAR column values on retrieval. This mode does not apply to VARCHAR columns, for which trailing spaces are retained on retrieval. The MySQL server can operate in different SQL ...
https://dev.mysql.com/doc/refman/8.0/en/string-type-syntax.html
Note Trailing spaces are removed when CHAR values are retrieved unless the PAD_CHAR_TO_FULL_LENGTH SQL mode is enabled. Note MySQL follows the standard SQL specification, and does not remove trailing spaces from VARCHAR values. The string data ...
https://dev.mysql.com/doc/refman/8.0/en/cast-functions.html
The BINARY operator also causes trailing spaces in comparisons to be significant. Unlike CHAR, NCHAR does not permit trailing character set information to be specified. Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY ...