PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filtering.html
It is also possible to modify the audit log tables directly using statements such as INSERT, UPDATE, and DELETE, but such changes do not affect filtering immediately. Note As of MySQL 5.7.13, for audit log filtering to work as described here, the ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-reference.html
If instead you modify the contents of those tables directly using statements such as INSERT, UPDATE, and DELETE, the changes do not affect filtering immediately. Unless those objects are installed, the audit_log plugin operates in legacy mode. Audit ...
https://dev.mysql.com/doc/refman/5.7/en/backup-policy.html
A full backup (a snapshot of the data at a point in time) can be done in MySQL with several tools. For example, MySQL Enterprise Backup can perform a physical backup of an entire instance, with optimizations to minimize overhead and avoid disruption ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-setting.html
It is possible to change the logging format to STATEMENT, but doing so at runtime leads very rapidly to errors because InnoDB can no longer perform inserts. You can select the binary logging format explicitly by starting the MySQL server with ...
https://dev.mysql.com/doc/refman/5.7/en/bit-functions.html
Table 12.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 ...
https://dev.mysql.com/doc/refman/5.7/en/calculating-days.html
CREATE TABLE t1 (year YEAR, month INT UNSIGNED, day INT UNSIGNED); INSERT INTO t1 VALUES(2000,1,1),(2000,1,20),(2000,1,30),(2000,2,2), (2000,2,23),(2000,2,23); The example table contains year-month-day values representing visits by users to the page. 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 ...
https://dev.mysql.com/doc/refman/5.7/en/cast-functions.html
Table 12.15 Cast Functions and Operators Name Description BINARY Cast a string to a binary string CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values from one data ...
https://dev.mysql.com/doc/refman/5.7/en/charset-conversion.html
To convert a binary or nonbinary string column to use a particular character set, use ALTER TABLE. For successful conversion to occur, one of the following conditions must apply: If the column has a binary data type (BINARY, VARBINARY, BLOB), all ...
https://dev.mysql.com/doc/refman/5.7/en/charset-errors.html
This section describes how the MySQL server uses character sets for constructing error messages. For information about the language of error messages (rather than the character set), see Section 10.12, “Setting the Error Message Language”. For ...
https://dev.mysql.com/doc/refman/5.7/en/charset-metadata.html
INSERT INTO t1 (latin1_column) SELECT USER(); This works because the contents of USER() are automatically converted to latin1 before the assignment. Metadata is “the data about the data.” Anything that describes the database—as opposed to ...