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/ansi-diff-comments.html
In this case, the generated statement looks like this: UPDATE account SET balance=balance--1 WHERE account_id=5752; balance--1 is valid standard SQL, but -- is interpreted as the start of a comment, and part of the expression is discarded. Standard ...MySQL also support extensions to this syntax that enable MySQL-specific SQL to be embedded in the comment; see Section 11.7, ...
https://dev.mysql.com/doc/refman/8.0/en/any-in-some-subqueries.html
Thus, these two statements are the same: SELECT s1 FROM t1 WHERE s1 = ANY (SELECT s1 FROM t2); SELECT s1 FROM t1 WHERE s1 IN (SELECT s1 FROM t2); IN and = ANY are not synonyms when used with an expression list. The syntax means “there is some b to ...The expression is TRUE if table t2 contains (21,14,7) because there is a value 7 in t2 that is less than ...
https://dev.mysql.com/doc/refman/8.0/en/assignment-operators.html
Table 14.6 Assignment Operators Name Description := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an UPDATE statement) := Assignment operator. Causes the user variable on the left hand side of the ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-disabling.html
The audit_log_disable variable can be set in a MySQL Server option file, in a command-line startup string, or at runtime using a SET statement; for example: SET GLOBAL audit_log_disable = true; Setting audit_log_disable to true disables the audit ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-security.html
By default, contents of audit log files produced by the audit log plugin are not encrypted and may contain sensitive information, such as the text of SQL statements. For security reasons, audit log files should be written to a directory accessible ...This can be changed by setting the audit_log_file system variable at server ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-formats.html
This helps to eliminate issues when replicating certain statements between a source and replica which are using different storage engines. If MySQL cannot make this guarantee, it marks the statement as potentially unreliable and issues the warning, ... The server uses several logging formats to record information in the binary log: Replication capabilities in MySQL originally were based on propagation of SQL statements from source to ...
https://dev.mysql.com/doc/refman/8.0/en/boolean-literals.html
The constants TRUE and FALSE evaluate to 1 and 0, respectively. mysql> SELECT TRUE, true, FALSE, false; -> 1, 1, 0, 0 .
https://dev.mysql.com/doc/refman/8.0/en/cannot-create.html
For example, to specify a directory of C:\temp, use these lines: [mysqld] tmpdir=C:/temp The C:\temp directory must exist and have sufficient space for the MySQL server to write to. Provided that the write error is to a test file, the error is not ... If you get an error of the following type for some queries, it means that MySQL cannot create a temporary file for the result set in the temporary directory: Can't create/write to file ...
https://dev.mysql.com/doc/refman/8.0/en/cannot-initialize-character-set.html
You might see an error like this if you have character set problems: MySQL Connection Failed: Can't initialize character set charset_name This error can have any of the following causes: The character set is a multibyte character set and you have ...In this case, you need to recompile the client by running CMake with the -DDEFAULT_CHARSET=charset_name ...
https://dev.mysql.com/doc/refman/8.0/en/charset-cyrillic-sets.html
The Cyrillic character sets and collations are for use with Belarusian, Bulgarian, Russian, Ukrainian, and Serbian (Cyrillic) languages. cp1251 (Windows Cyrillic) collations: cp1251_bin cp1251_bulgarian_ci cp1251_general_ci (default) ...