No cache version.
Caching disabled. Default setting for this page:enabled (code DEF204)
If the display is too slow, you can disable the user mode to view the cached version.
Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/populating-spatial-columns.html
Values should be stored in internal geometry format, but you can convert them to that format from either Well-Known Text (WKT) or Well-Known Binary (WKB) format. After you have created spatial columns, you can populate them with spatial data. For ...
https://dev.mysql.com/preface.html
Differences between minor versions of MySQL 8.0 are noted in the present text with reference to release numbers (8.0.x). This is the Reference Manual for the MySQL Database System, version 8.0, through release 8.0.20. This manual is not intended ...
https://dev.mysql.com/purge-binary-logs.html
(Bug #18199, Bug #18453) To handle such errors, edit the .index file (which is a simple text file) manually to ensure that it lists only the binary log files that are actually present, then run again the PURGE BINARY LOGS statement that failed.
https://dev.mysql.com/replace.html
REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ... | VALUES row_constructor_list } REPLACE [LOW_PRIORITY | DELAYED] ...
https://dev.mysql.com/replication-features-functions.html
The GET_LOCK(), RELEASE_LOCK(), IS_FREE_LOCK(), and IS_USED_LOCK() functions that handle user-level locks are replicated without the slave knowing the concurrency context on the master. INTO, and then store the variable in the table, like this: ...
https://dev.mysql.com/replication-features-max-allowed-packet.html
If you are replicating large column values (such as might be found in TEXT or BLOB columns) and max_allowed_packet is too small on the master, the master fails with an error, and the slave shuts down the I/O thread. max_allowed_packet sets an upper ...
https://dev.mysql.com/replication-howto-repuser.html
Although you do not have to create an account specifically for replication, you should be aware that the replication user name and password are stored in plain text in the master info repository table mysql.slave_master_info (see Section 17.2.4.2, ... Each slave connects to the master using a MySQL user name and password, so there must be a user account on the master that the slave can use to ...
https://dev.mysql.com/replication-rules-examples.html
This can sometimes lead to results that seem counterintuitive, and that may be different depending on whether you are using statement-based or row-based replication; see the text for an example. This section provides additional explanation and ...
https://dev.mysql.com/replication-snapshot-method.html
This method also does not work reliably if the master and slave have different values for ft_stopword_file, ft_min_word_len, or ft_max_word_len and you are copying tables having full-text indexes. If the master database contains existing data it is ...
https://dev.mysql.com/replication-solutions-diffengines.html
Configuring different engines on the master and slave depends on how you set up the initial replication process: If you used mysqldump to create the database snapshot on your master, you could edit the dump file text to change the engine type used ... It does not matter for the replication process whether the source table on the master and the replicated table on the slave use different engine ...
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-fct-text-p-28.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.
