https://dev.mysql.com/connection-access.html
From MySQL's point of view, the encrypted password is the real password, so you should never give anyone access to it. When you attempt to connect to a MySQL server, the server accepts or rejects the connection based on these conditions: Your ...
https://dev.mysql.com/replication-solutions-switch.html
On the other slaves Slave 2 and Slave 3, use STOP SLAVE and CHANGE MASTER TO MASTER_HOST='Slave1' (where 'Slave1' represents the real host name of Slave 1). You can tell a slave to change to a new master using the CHANGE MASTER TO statement. The ...
https://dev.mysql.com/contributors.html
Per Eric Olsson For constructive criticism and real testing of the dynamic record format. Although Oracle Corporation and/or its affiliates own all copyrights in the MySQL server and the MySQL manual, we wish to recognize those who have made ...
https://dev.mysql.com/control-flow-functions.html
mysql> SELECT IFNULL(1,0); -> 1 mysql> SELECT IFNULL(NULL,10); -> 10 mysql> SELECT IFNULL(1/0,10); -> 10 mysql> SELECT IFNULL(1/0,'yes'); -> 'yes' The default return type of IFNULL(expr1,expr2) is the more “general” of the two expressions, in ...
https://dev.mysql.com/mysql-nutshell.html
The functions CAST() and CONVERT() now support conversions to types DOUBLE, FLOAT, and REAL. This section summarizes what has been added to, deprecated in, and removed from MySQL 8.0. A companion section lists MySQL server options and variables ...
https://dev.mysql.com/create-function-udf.html
CREATE [AGGREGATE] FUNCTION function_name RETURNS {STRING|INTEGER|REAL|DECIMAL} SONAME shared_library_name A user-defined function (UDF) is a way to extend MySQL with a new function that works like a native (built-in) MySQL function such as ABS() ...function_name is the name that should be used in SQL statements to invoke the ...
https://dev.mysql.com/mysql-cluster-ndbinfo-restart-info.html
Each entry in the table corresponds to a node restart status report in real time from a data node with the given node ID. Only the most recent report for any given node is shown. The following table provides information about the columns in the ...
https://dev.mysql.com/user-defined-functions-table.html
The value is one of int, decimal, real, char, or row. The user_defined_functions table contains a row for each user-defined function (UDF) registered by a server component or plugin, or by a CREATE FUNCTION statement. user_defined_functions has ...
https://dev.mysql.com/performance-schema-examples.html
The Performance Schema is a tool to help a DBA do performance tuning by taking real measurements instead of “wild guesses.” This section demonstrates some ways to use the Performance Schema for this purpose. The discussion here relies on the ...
https://dev.mysql.com/mysql-cluster-options-variables.html
The real (internal) name of the table can be seen in the output of SHOW CREATE TABLE. Ndb_conflict_trans_row_reject_count Used in NDB Cluster Replication conflict resolution, this status variable shows the total number of rows realigned due to being ... This section provides information about MySQL server options, server and status variables that are specific to NDB ...
