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/selecting-all.html
For example, you may happen to think that the birth date for Bowser does not seem quite right. Fix only the erroneous record with an UPDATE statement: mysql> UPDATE pet SET birth = '1989-08-31' WHERE name = 'Bowser'; The UPDATE changes only the ...
https://dev.mysql.com/doc/refman/5.7/en/source-installation-prerequisites.html
After Boost is installed, tell the build system where the Boost files are placed according to the value set for the WITH_BOOST option when you invoke CMake. To install MySQL from source, the following system requirements must be satisfied, ...Some ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-geohash-functions.html
Geohash is a system for encoding latitude and longitude coordinates of arbitrary precision into a text string. ST_GeoHash(longitude, latitude, max_length), ST_GeoHash(point, max_length) Returns a geohash string in the connection character set and ...Geohash values are strings that contain only characters chosen from ...
https://dev.mysql.com/doc/refman/5.7/en/stop-slave.html
You can control how long STOP SLAVE waits before timing out by setting the rpl_stop_slave_timeout system variable. ] thread_type: IO_THREAD | SQL_THREAD channel_option: FOR CHANNEL channel Stops the replication threads. Recommended best practice is ...Like START SLAVE, this statement may be used with the IO_THREAD and SQL_THREAD options to name the thread or threads to be ...
https://dev.mysql.com/doc/refman/5.7/en/system-variables-controlling-tracing.html
optimizer_trace_features: Enables or disables selected features of the MySQL Optimizer, using the syntax shown here: SET optimizer_trace_features=option=value[,option=value][,...] option: {greedy_search | range_optimizer | dynamic_range | ... The ...
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-installation.html
For general information about installing plugins, see Section 5.5.1, “Installing and Uninstalling Plugins”. If necessary, configure the plugin directory location by setting the value of plugin_dir at server startup. The file name suffix differs ... This section describes how to install MySQL Enterprise Thread ...
https://dev.mysql.com/doc/refman/5.7/en/traceable-statements.html
Statements which are traceable are listed here: SELECT INSERT REPLACE UPDATE DELETE EXPLAIN with any of the preceding statements SET DO DECLARE, CASE, IF, and RETURN as used in stored routines CALL Tracing is supported for both INSERT and REPLACE ...For statements which are prepared and executed in separate steps, preparation and execution are traced ...
https://dev.mysql.com/doc/refman/5.7/en/create-function-loadable.html
CREATE FUNCTION requires the INSERT privilege for the mysql system database because it adds a row to the mysql.func system table to register the function. For more information, see Section 5.6.1, “Installing and Uninstalling Loadable Functions”.
https://dev.mysql.com/doc/refman/5.7/en/drop-function-loadable.html
It requires the DELETE privilege for the mysql system database because it removes the row from the mysql.func system table that registers the function. Because DROP FUNCTION removes the mysql.func row for the dropped function, the server does not ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-elements.html
Server-side plugins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL_WHITELIST implement INFORMATION_SCHEMA tables that provide views into the registered profiles. MySQL Enterprise Firewall is based on a plugin library that includes these elements: A ...