MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 11 to 20 of 50 total results

14.8.1 String Comparison Functions and Operators

https://dev.mysql.com/doc/refman/9.7/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 ...

14.9.2 Boolean Full-Text Searches

https://dev.mysql.com/doc/refman/9.7/en/fulltext-boolean.html

Specifying a trailing plus or minus sign causes InnoDB to report a syntax error. The boolean full-text search capability supports the following operators: + A leading or trailing plus sign indicates that this word must be present in each row that is ... MySQL can perform boolean full-text searches using the IN BOOLEAN MODE ...

15.7.7.5 SHOW COLLATION Statement

https://dev.mysql.com/doc/refman/9.7/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 ...

6.6.6 myisampack — Generate Compressed, Read-Only MyISAM Tables

https://dev.mysql.com/doc/refman/9.7/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.

28.3.6 The INFORMATION_SCHEMA COLLATIONS Table

https://dev.mysql.com/doc/refman/9.7/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 ...

15.2.14 Set Operations with UNION, INTERSECT, and EXCEPT

https://dev.mysql.com/doc/refman/9.7/en/set-operations.html

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 * ...

7.1.11 Server SQL Modes

https://dev.mysql.com/doc/refman/9.7/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 ...

13.3.1 String Data Type Syntax

https://dev.mysql.com/doc/refman/9.7/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 ...

14.10 Cast Functions and Operators

https://dev.mysql.com/doc/refman/9.7/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 ...

14.1 Built-In Function and Operator Reference

https://dev.mysql.com/doc/refman/9.7/en/built-in-function-reference.html

The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...

Displaying 11 to 20 of 50 total results