PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/string-literals.html
These statements are equivalent: SELECT N'some text'; SELECT n'some text'; SELECT _utf8'some text'; For information about these forms of string syntax, see Section 12.3.7, “The National Character Set”, and Section 12.3.8, “Character Set ... A ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/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/8.0/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/8.0/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/8.0/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/8.0/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/8.0/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/8.0/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. As of NDB 8.0.16: For NDB tables, ON DELETE CASCADE is not supported where the child table contains one or ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...