PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-features-functions.html
For this reason, if you select from the replica's copy of mytable after the CREATE TABLE and INSERT statements just shown have been replicated, you might expect mycol to contain the value 2009-09-01 18:00:00. Therefore, these functions should not be ... Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and LOAD_FILE() functions are replicated without change and thus do not work reliably on the replica unless row-based replication is ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-source.html
On the source and each replica, you must set the server_id system variable to establish a unique replication ID. It is not possible to restrict the effects of these two variables to a single table; these variables control the behavior of all ...
https://dev.mysql.com/doc/refman/8.0/en/replication-upgrade.html
Upgrade Procedure With Table Repair Or Rebuild Some upgrades may require that you drop and re-create database objects when you move from one MySQL series to the next. Perform any table repair or rebuilding operations needed to re-create database ...
https://dev.mysql.com/doc/refman/8.0/en/get-diagnostics.html
For example: mysql> GET DIAGNOSTICS CONDITION 1 @p5 = SCHEMA_NAME, @p6 = TABLE_NAME; mysql> SELECT @p5, @p6; +------+------+ | @p5 | @p6 | +------+------+ | | | +------+------+ In standard SQL, if there are multiple conditions, the first condition ... GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-columns-list.html
See Section 15.1.20, “CREATE TABLE Statement”, for additional information about PARTITION BY LIST COLUMNS() syntax. This is a variant of LIST partitioning that enables the use of multiple columns as partition keys, and for columns of data types ...
https://dev.mysql.com/doc/refman/8.0/en/option-files.html
Many option files are plain text files, created using any text editor. It is created by the server upon execution of SET PERSIST or SET PERSIST_ONLY statements. If an option file you want to use does not exist, create it using the appropriate ...
https://dev.mysql.com/doc/refman/8.0/en/signal.html
Signals can be raised within exception handlers: CREATE PROCEDURE p () BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN SIGNAL SQLSTATE VALUE '99999' SET MESSAGE_TEXT = 'An error occurred'; END; DROP TABLE no_such_table; END; CALL p() reaches the ...Without SIGNAL, it is necessary to resort to workarounds such as deliberately referring to a nonexistent table to cause a routine to return an ...
https://dev.mysql.com/doc/refman/8.0/en/source-configuration-options.html
CMake Option Reference General Options Installation Layout Options Storage Engine Options Feature Options Compiler Flags CMake Options for Compiling NDB Cluster CMake Option Reference The following table shows the available CMake options. The CMake ...
https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html
The following table shows the plugin names on the server and client sides. If caching_sha2_password is the default authentication plugin, a simpler CREATE USER syntax can be used. As a result, it is possible to create the account and set its ...
https://dev.mysql.com/doc/refman/8.0/en/copying-databases.html
In cases where you need to transfer databases between different architectures, you can use mysqldump to create a file containing SQL statements. Note If GTIDs are in use on the server where you create the dump (gtid_mode=ON), by default, mysqldump ...You can then transfer the file to the other machine and feed it as input to the mysql ...