PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.3Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/prepare.html
A statement prepared in stored program context cannot refer to stored procedure or function parameters or local variables because they go out of scope when the program ends and would be unavailable were the statement to be executed later outside the ...A prepared statement created within a stored program continues to exist after the program finishes executing and can be executed outside the program ...
https://dev.mysql.com/doc/refman/8.0/en/replication-binlog-encryption-encryption-keys.html
A server instance only creates and removes keys generated for itself, but it can read keys generated for other instances if they are stored in the keyring, as in the case of a server instance that has been cloned by file copying. The sequence number ... The binary log encryption keys used to encrypt the file passwords for the log files are 256-bit keys that are generated specifically for each MySQL server instance using MySQL Server's keyring service (see Section 8.4.4, “The MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-drop-if-exists.html
IF EXISTS statements for stored programs (stored procedures and functions, triggers, and events) are also replicated, even if the stored program to be dropped does not exist on the source. The DROP DATABASE IF EXISTS, DROP TABLE IF EXISTS, and DROP ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-generated-columns.html
CREATE TABLE t1 (c1 INT); ALTER TABLE t1 ADD COLUMN c2 INT GENERATED ALWAYS AS (c1 + 1) STORED; The data type and expression of generated columns can be modified. CREATE TABLE t1 (c1 INT, c2 INT GENERATED ALWAYS AS (c1 + 1) STORED); ALTER TABLE t1 ... ALTER TABLE operations permitted for generated columns are ADD, MODIFY, and ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-range.html
Now, any rows whose store_id column value is greater than or equal to 16 (the highest value defined) are stored in partition p3. At some point in the future—when the number of stores has increased to 25, 30, or more—you can use an ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-digests.html
For each digest, a representative statement that produces the digest is stored as a sample. The copy of the normalized statement digest is stored in the appropriate Performance Schema tables, along with the SHA-256 hash value computed from the ...
https://dev.mysql.com/doc/refman/8.0/en/account-activity-auditing.html
Applications can use the following guidelines to perform SQL-based auditing that ties database activity to MySQL accounts. When a client connects successfully, the server authenticates the client to a particular row in this table. The User and Host ...
https://dev.mysql.com/doc/refman/8.0/en/account-locking.html
It also does not affect the ability to execute stored programs or views that have a DEFINER attribute naming the locked account. That is, the ability to use a proxied account or stored programs or views is not affected by locking the account. For ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-formats.html
Only top-level statements are logged, not statements within stored programs such as triggers or stored procedures. The MySQL server calls the audit log plugin to write an audit record to its log file whenever an auditable event occurs. Typically ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-restrictions.html
Only top-level statements are logged, not statements within stored programs such as triggers or stored procedures. MySQL Enterprise Audit is subject to these general restrictions: Only SQL statements are logged. Changes made by no-SQL APIs, such as ...