PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/alter-server.html
ALTER SERVER server_name OPTIONS (option [, option] ...) Alters the server information for server_name, adjusting any of the options permitted in the CREATE SERVER statement. For example, to update the USER option: ALTER SERVER s OPTIONS (USER ...
https://dev.mysql.com/doc/refman/5.7/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 <> SOME (SELECT s1 FROM t2); Use of the word SOME is rare, but this example shows why it might be useful. The expression is ...
https://dev.mysql.com/doc/refman/5.7/en/apache.html
There are programs that let you authenticate your users from a MySQL database and also let you write your log files into a MySQL table.
https://dev.mysql.com/doc/refman/5.7/en/audit-log-restrictions.html
MySQL Enterprise Audit is subject to these general restrictions: Only SQL statements are logged. Changes made by no-SQL APIs, such as memcached, Node.JS, and the NDB API, are not logged. Only top-level statements are logged, not statements within ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-security.html
This can be changed by setting the audit_log_file system variable at server startup. 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 ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log.html
To identify the relevant instruments, use this query: SELECT NAME FROM performance_schema.setup_instruments WHERE NAME LIKE '%/alog/%'; . Note MySQL Enterprise Audit is an extension included in MySQL Enterprise Edition, a commercial product. MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/backup-strategy-summary.html
If you have such safe media, this technique can also be good for disk load balancing (which results in a performance improvement). In case of an operating system crash or power failure, InnoDB itself does all the job of recovering data. But to make ...
https://dev.mysql.com/doc/refman/5.7/en/bit-value-literals.html
A leading 0b is case-sensitive and cannot be written as 0B. In numeric contexts, MySQL treats a bit literal like an integer. To ensure numeric treatment of a bit literal, use it in numeric context. For example, a bit literal assigned to a ...
https://dev.mysql.com/doc/refman/5.7/en/calculating-days.html
The following example shows how you can use the bit group functions to calculate the number of days per month a user has visited a Web page. CREATE TABLE t1 (year YEAR, month INT UNSIGNED, day INT UNSIGNED); INSERT INTO t1 ...
https://dev.mysql.com/doc/refman/5.7/en/cannot-create.html
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 '\\sqla3fe_0.ism'. The preceding error is a typical message for ...