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/reset-master.html
The value of the gtid_purged system variable is set to an empty string (''), the global value (but not the session value) of the gtid_executed system variable is set to an empty string, and the mysql.gtid_executed table is cleared (see ... RESET ...
https://dev.mysql.com/doc/refman/5.7/en/show-slave-status.html
An error number of 0 and message of the empty string mean “no error.” If the Last_IO_Error value is not empty, the error values also appear in the replica's error log. An error number of 0 and message of the empty string mean “no error.” If ... SHOW SLAVE STATUS [FOR CHANNEL channel] This statement provides status information on essential parameters of the replica ...
https://dev.mysql.com/doc/refman/5.7/en/sys-execute-prepared-stmt.html
Given an SQL statement as a string, executes it as a prepared statement. Parameters in_query LONGTEXT CHARACTER SET utf8: The statement string to execute. The prepared statement is deallocated after execution, so it is not subject to reuse. Thus, ...
https://dev.mysql.com/doc/refman/5.7/en/working-with-null.html
A common error when working with NULL is to assume that it is not possible to insert a zero or an empty string into a column defined as NOT NULL, but this is not the case. The NULL value can be surprising until you get used to it. Conceptually, ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations.html
The following constructs are not permitted in partitioning expressions: Stored procedures, stored functions, loadable functions, or plugins. For a list of SQL functions which are permitted in partitioning expressions, see Section 22.6.3, ... This ...
https://dev.mysql.com/doc/refman/5.7/en/password-hashing.html
This includes removal of the mysql_old_password authentication plugin and the OLD_PASSWORD() function. The client can do this by using the PASSWORD() function to generate a password hash, or by using a password-generating statement (CREATE USER, ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filtering.html
Note As of MySQL 5.7.13, for audit log filtering to work as described here, the audit log plugin and the accompanying audit tables and functions must be installed. If the plugin is installed without the accompanying audit tables and functions ...
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/faqs-mysql-cluster.html
The logical or functional elements of a cluster are referred to as nodes, and a computer housing a cluster node is sometimes referred to as a cluster host. Data node functionality is handled by instances of the NDB data node process ndbd. This is ...
https://dev.mysql.com/doc/refman/5.7/en/features.html
Implements SQL functions using a highly optimized class library that should be as fast as possible. Statements and Functions Full operator and function support in the SELECT list and WHERE clause of queries. Support for group functions (COUNT(), ...