PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-lifecycle.html
Because gtid_next is set to the GTID already assigned by the source, the replica does not attempt to generate a new GTID for this transaction, but instead uses the GTID stored in gtid_next. What changes are assigned a GTID? The typical scenario is ... The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the replication source ...
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
Normally, you generate the next sequence number for the column by inserting either NULL or 0 into it. A simple description of this mode is “give an error instead of a warning” when inserting an incorrect value into a column. It does not apply to ... The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html
minimal: Log only those columns in the before image that are required to identify the row to be changed; log only those columns in the after image where a value was specified by the SQL statement, or generated by auto-increment. Set to NONE to ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-foreign-keys.html
Prior to 5.7.16, a foreign key constraint cannot reference a secondary index defined on a virtual generated column. A foreign key constraint on a stored generated column cannot use CASCADE, SET NULL, or SET DEFAULT as ON UPDATE referential actions, ...A foreign key relationship involves a parent table that holds the initial column values, and a child table with column values that reference the parent column ...
https://dev.mysql.com/doc/refman/5.7/en/example-auto-increment.html
You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is enabled. For example: INSERT INTO animals (id,name) VALUES(0,'groundhog'); If the column is declared NOT NULL, it is also ...
https://dev.mysql.com/doc/refman/5.7/en/insert.html
If strict SQL mode is enabled, an INSERT statement generates an error if it does not specify an explicit value for every column that has no default value. If a generated column is inserted into explicitly, the only permitted value is DEFAULT. For ...
https://dev.mysql.com/doc/refman/5.7/en/creating-ssl-files-using-openssl.html
Note There are easier alternatives to generating the files required for SSL than the procedure described here: Let the server autogenerate them or use the mysql_ssl_rsa_setup program. Important Whatever method you use to generate the certificate and ... This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-functions.html
Example: mysql> SELECT mask_ssn('909-63-6922'), mask_ssn('abcdefghijk'); +-------------------------+-------------------------+ | mask_ssn('909-63-6922') | mask_ssn('abcdefghijk') | +-------------------------+-------------------------+ | XXX-XX-6922 ...If a string return value should be in a different character set, convert ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-usage.html
Note The examples here supply function arguments using the random value generation functions that return the appropriate type of value. For more information about generation functions, see Generating Random Data with Specific Characteristics.
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 ...