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/call.html
When the procedure returns, a client program can also obtain the number of rows affected for the final statement executed within the routine: At the SQL level, call the ROW_COUNT() function; from the C API, call the mysql_affected_rows() function.
https://dev.mysql.com/doc/refman/5.7/en/condition-handling.html
Conditions may arise during stored program execution that require special handling, such as exiting the current program block or continuing execution. Handlers can be defined for general conditions such as warnings or exceptions, or for specific ...
https://dev.mysql.com/doc/refman/5.7/en/gis-data-formats.html
For example, both of the following function calls are valid, whereas before MySQL 5.7.9 the second one produces an error: ST_MPointFromText('MULTIPOINT (1 1, 2 2, 3 3)') ST_MPointFromText('MULTIPOINT ((1 1), (2 2), (3 3))') As of MySQL 5.7.9, output ...The second uses a WKT representation converted to a Point with ... Two standard spatial data formats are used to represent geometry objects in queries: Well-Known Text (WKT) format Well-Known Binary (WKB) format Internally, MySQL stores geometry ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-functions.html
gen_blacklist(str, dictionary_name, replacement_dictionary_name) Replaces a term present in one dictionary with a term from a second dictionary and returns the replacement term. Example: mysql> SELECT ...If a string return value should be in a ...
https://dev.mysql.com/doc/refman/5.7/en/replication-threads.html
If the replica stops before the SQL thread has executed all the fetched statements, the I/O thread has at least fetched everything so that a safe copy of the transactions is stored locally in the replica's relay logs, ready for execution the next ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-installation.html
To verify that, connect to the server and execute this statement: mysql> SHOW GLOBAL VARIABLES LIKE 'mysql_firewall_mode'; +---------------------+-------+ | Variable_name | Value | +---------------------+-------+ | mysql_firewall_mode | ON | ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-windows-initial-start.html
Once the NDB Cluster executables and needed configuration files are in place, performing an initial start of the cluster is simply a matter of starting the NDB Cluster executables for all nodes in the cluster. This means that, if the management ...
https://dev.mysql.com/doc/refman/5.7/en/no-login-pluggable-authentication.html
Use cases for this plugin include: Accounts that must be able to execute stored programs and views with elevated privileges without exposing those privileges to ordinary users. With this plugin-loading method, the option must be given each time the ... The mysql_no_login server-side authentication plugin prevents all client connections to any account that uses ...
https://dev.mysql.com/doc/refman/5.7/en/document-store-setting-up.html
Note MySQL Installer enables you to perform this and the next step (Install the X Plugin) at the same time for new installations on Microsoft Windows. If the upgrade is not run, X Plugin fails to start with the error message There was an error when ... To use MySQL 5.7 as a document store, the X Plugin needs to be ...
https://dev.mysql.com/doc/refman/5.7/en/server-logs.html
Log flushing occurs when you issue a FLUSH LOGS statement; execute mysqladmin with a flush-logs or refresh argument; or execute mysqldump with a --flush-logs option. You can control the general query and slow query logs during runtime. MySQL Server ...