PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/sys-list-add.html
Adds a value to a comma-separated list of values and returns the result. This function and list_drop() can be useful for manipulating the value of system variables such as sql_mode and optimizer_switch that take a comma-separated list of values.
https://dev.mysql.com/doc/refman/9.7/en/sys-list-drop.html
For more information, see the description of list_add() Parameters in_list TEXT: The list to be modified. Removes a value from a comma-separated list of values and returns the result.
https://dev.mysql.com/doc/refman/9.7/en/adding-collation.html
Additional Resources Example showing how to add a collation for full-text searches: Section 14.9.7, “Adding a User-Defined Collation for Full-Text Indexing” The Unicode Collation Algorithm (UCA) specification: ... Warning User-defined collations ...
https://dev.mysql.com/doc/refman/9.7/en/alter-user.html
Important Under some circumstances, ALTER USER may be recorded in server logs or on the client side in a history file such as ~/.mysql_history, which means that cleartext passwords may be read by anyone having read access to that information. An ...
https://dev.mysql.com/doc/refman/9.7/en/bit-functions.html
You can specify arguments to bit operations using hexadecimal literals or bit literals with the intent that they represent numbers; MySQL evaluates bit operations in numeric context when all bit arguments are hexadecimal or bit literals. In numeric ... Table 14.17 Bit Functions and Operators Name Description & Bitwise AND >> Right shift << Left shift ^ Bitwise XOR BIT_COUNT() Return the number of bits that are set | Bitwise OR ~ Bitwise inversion The following list describes available bit functions and operators: | Bitwise ...
https://dev.mysql.com/doc/refman/9.7/en/char.html
For nonbinary strings (CHAR, VARCHAR, and TEXT values), the string collation pad attribute determines treatment in comparisons of trailing spaces at the end of strings. The CHAR and VARCHAR types are similar, but differ in the way they are stored ...
https://dev.mysql.com/doc/refman/9.7/en/charset-applications.html
The examples shown here assume use of the latin1 character set and latin1_swedish_ci collation in particular contexts as an alternative to the defaults of utf8mb4 and utf8mb4_0900_ai_ci. For example, if you intend to send statements using UTF-8 text ... For applications that store data using the default MySQL character set and collation (utf8mb4, utf8mb4_0900_ai_ci), no special configuration should be ...
https://dev.mysql.com/doc/refman/9.7/en/charset-binary-collations.html
Nonbinary strings (as stored using the CHAR, VARCHAR, and TEXT data types) have a character set and collation other than binary. For nonbinary strings (CHAR, VARCHAR, and TEXT values), the string collation pad attribute determines treatment in ...
https://dev.mysql.com/doc/refman/9.7/en/charset-column.html
Every “character” column (that is, a column of type CHAR, VARCHAR, a TEXT type, or any synonym) has a column character set and a column collation. CREATE TABLE t1 ( col1 CHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ) CHARACTER SET ...
https://dev.mysql.com/doc/refman/9.7/en/create-table-foreign-keys.html
Consequently, BLOB and TEXT columns cannot be included in a foreign key because indexes on those columns must always include a prefix length. For NDB tables, ON DELETE CASCADE is not supported where the child table contains one or more columns of ...