PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/start-replica.html
For the thread type options, you can specify IO_THREAD, SQL_THREAD, both of these, or neither of them. START REPLICA with no thread type options starts all of the replication threads, and so does START REPLICA with both of the thread type options. A ... START REPLICA [thread_types] [until_option] [connection_options] [channel_option] thread_types: [thread_type [, thread_type] ...
https://dev.mysql.com/doc/refman/8.0/en/string-functions.html
TRIM([{BOTH | LEADING | TRAILING} [remstr] FROM] str), TRIM([remstr FROM] str) Returns the string str with all remstr prefixes or suffixes removed. If none of the specifiers BOTH, LEADING, or TRAILING is given, BOTH is assumed. mysql> SELECT TRIM(' ...For functions that operate on string positions, the first position is numbered ...
https://dev.mysql.com/doc/refman/8.0/en/type-conversion.html
The following rules describe how conversion occurs for comparison operations: If one or both arguments are NULL, the result of the comparison is NULL, except for the NULL-safe <=> equality comparison operator. If both arguments in a comparison ...
https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html
This change affects both the server and the libmysqlclient client library: For the server, the default value of the default_authentication_plugin system variable changes from mysql_native_password to caching_sha2_password. However, the preceding ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-partition-operations.html
Both options take a comma-separated list of one or more partition names. TABLESPACE on subpartitioned tables, both partition and subpartition names are allowed. Partitioning-related clauses for ALTER TABLE can be used with partitioned tables for ...
https://dev.mysql.com/doc/refman/8.0/en/command-line-options.html
The MySQL server has certain command options that may be specified only at startup, and a set of system variables, some of which may be set at startup, at runtime, or both. Program options specified on the command line follow these rules: Options ...
https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html
This operator performs an equality comparison like the = operator, but returns 1 rather than NULL if both operands are NULL, and 0 rather than NULL if one operand is NULL. Table 14.4 Comparison Operators Name Description > Greater than operator >= ...
https://dev.mysql.com/doc/refman/8.0/en/connection-control-plugin-installation.html
Note It is possible to install one plugin without the other, but both must be installed for full connection control capability. The connection_control_min_connection_delay and connection_control_max_connection_delay system variables both have ...
https://dev.mysql.com/doc/refman/8.0/en/create-event.html
It specifies that the event executes one time only at the date and time given by timestamp, which must include both the date and time, or must be an expression that resolves to a datetime value. You may use STARTS, ENDS, both, or neither in an EVERY ... CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ...
https://dev.mysql.com/doc/refman/8.0/en/datetime.html
The DATETIME type is used for values that contain both date and time parts. The TIMESTAMP data type is used for values that contain both date and time parts. This occurs because the same time zone was not used for conversion in both directions. This ...