PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.7Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-formats.html
Valid XML characters are: #x9 | #xA | #xD | [#x20-#xD7FF] | [#xE000-#xFFFD] | [#x10000-#x10FFFF] The following elements are mandatory in every <AUDIT_RECORD> element: <NAME> A string representing the type of instruction that generated the audit ...
https://dev.mysql.com/doc/refman/5.7/en/charset-literal.html
Every character string literal has a character set and a collation. For the simple statement SELECT 'string', the string has the connection default character set and collation defined by the character_set_connection and collation_connection system ...Examples: SELECT 'abc'; SELECT _latin1'abc'; SELECT _binary'abc'; SELECT _utf8'abc' COLLATE utf8_danish_ci; Character set introducers and the COLLATE clause are implemented according to standard SQL ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-foreign-keys.html
For nonbinary (character) string columns, the character set and collation must be the same. SET NULL: Delete or update the row from the parent table and set the foreign key column or columns in the child table to NULL. Both ON DELETE SET NULL and ON ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/refman/5.7/en/case-sensitivity.html
For nonbinary strings (CHAR, VARCHAR, TEXT), string searches use the collation of the comparison operands. For binary strings (BINARY, VARBINARY, BLOB), comparisons use the numeric values of the bytes in the operands; this means that for alphabetic ...Simple comparison operations (>=, >, =, <, <=, sorting, and grouping) are based on each character's “sort value.” Characters with the same sort value are treated as the same ...
https://dev.mysql.com/doc/refman/5.7/en/string-functions-charset.html
MySQL has many operators and functions that return a string. This section answers the question: What is the character set and collation of such a string? For simple functions that take string input and return a string result as output, the output's ...If explicit COLLATE Y and COLLATE Z occur, raise an ...
https://dev.mysql.com/doc/refman/5.7/en/replace-utility.html
The replace utility program changes strings in place in files or on the standard input. < file_name from represents a string to look for and to represents its replacement. Use the -- option to indicate where the string-replacement list ends and the ...Note The replace utility is deprecated as of MySQL 5.7.18 and is removed in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-character.html
For character and string columns, follow these guidelines: Use binary collation order for fast comparison and sort operations, when you do not need language-specific collation features. When comparing values from different columns, declare those ...
https://dev.mysql.com/doc/refman/5.7/en/create-index.html
However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary string types (BINARY, ... CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ...
https://dev.mysql.com/doc/refman/5.7/en/logical-operators.html
For example, the following statements all assess to TRUE: mysql> SELECT 10 IS TRUE; -> 1 mysql> SELECT -10 IS TRUE; -> 1 mysql> SELECT 'string' IS NOT NULL; -> 1 NOT, ! Logical NOT. Table 12.5 Logical Operators Name Description AND, && Logical AND ...Most of this is common to different SQL database servers, although some servers may return any nonzero value for ...
https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-foreign-keys.html
If ON UPDATE CASCADE or ON UPDATE SET NULL recurses to update the same table it has previously updated during the same cascade, it acts like RESTRICT. This means that you cannot use self-referential ON UPDATE CASCADE or ON UPDATE SET NULL operations. A self-referential ON DELETE SET NULL, on the other hand, is possible, as is a self-referential ON DELETE ...For example, if you define a RESTRICT type constraint, ...