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/create-table-generated-columns.html
Generated column definitions have this syntax: col_name data_type [GENERATED ALWAYS] AS (expr) [VIRTUAL | STORED] [NOT NULL | NULL] [UNIQUE [KEY]] [[PRIMARY] KEY] [COMMENT 'string'] AS (expr) indicates that the column is generated and defines the ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-installation.html
To remove it, execute the following statements: DROP TABLE IF EXISTS mysql.audit_log_user; DROP TABLE IF EXISTS mysql.audit_log_filter; UNINSTALL PLUGIN audit_log; DROP FUNCTION audit_log_filter_set_filter; DROP FUNCTION ... This section describes ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-logging-configuration.html
To set or get an encryption password at runtime, use these audit log functions: To set the current encryption password, invoke audit_log_encryption_password_set(). For additional information about audit log encryption functions, see Audit Log ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-types.html
The function may consist of any expression valid in MySQL that yields an integer value. This type of partitioning is similar to partitioning by HASH, except that only one or more columns to be evaluated are supplied, and the MySQL server provides ...
https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html
ALTER ROUTINE Enables use of statements that alter or drop stored routines (stored procedures and functions). CREATE ROUTINE Enables use of statements that create stored routines (stored procedures and functions). EXECUTE Enables use of statements ... The privileges granted to a MySQL account determine which operations the account can ...
https://dev.mysql.com/doc/refman/5.7/en/replication-sbr-rbr.html
Examples of such Data Modification Language (DML) statements include the following: A statement that depends on a loadable function or stored program that is nondeterministic, since the value returned by such a function or stored program depends on ...For most users, the mixed replication format should provide the best combination of data integrity and ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-options-variables.html
Important Because each SQL node using connection pooling occupies multiple API node slots—each slot having its own node ID in the cluster—you must not use a node ID as part of the cluster connection string when starting any mysqld process that ... This section provides information about MySQL server options, server and status variables that are specific to NDB ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-porting-mysql.html
In any query that performs arithmetic using column values, use the CAST() function to convert the values from string to integer, or to some other numeric type. If there is a short numeric primary key column in an InnoDB table, use it as the unique ... Consider these aspects of memcached applications when adapting an existing MySQL schema or application to use the daemon_memcached plugin: memcached keys cannot contain spaces or newlines, because these characters are used as separators in the ASCII ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbd-definition.html
Data Memory, Index Memory, and String Memory DataMemory and IndexMemory are [ndbd] parameters specifying the size of memory segments used to store the actual records and their indexes. StringMemory Version (or later) NDB 7.5.0 Type or units % or ...
https://dev.mysql.com/doc/refman/5.7/en/sys-format-bytes.html
Given a byte count, converts it to human-readable format and returns a string consisting of a value and a units indicator. Depending on the size of the value, the units part is bytes, KiB (kibibytes), MiB (mebibytes), GiB (gibibytes), TiB ...