PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-commands.html
mysql sends each SQL statement that you issue to the server to be executed. There is also a set of commands that mysql itself interprets. For a list of these commands, type help or \h at the mysql> prompt: mysql> help List of all MySQL commands: ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations-functions.html
This section discusses limitations in MySQL Partitioning relating specifically to functions used in partitioning expressions. Each of these functions returns an integer only if it is passed an argument of an exact numeric type, such as one of the ...
https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html
type is one of the following data types: FLOAT DOUBLE DECIMAL SIGNED UNSIGNED DATE TIME DATETIME YEAR (MySQL 8.0.22 and later) YEAR values of one or two digits are not supported. The functions in this section perform search or comparison operations ...
https://dev.mysql.com/doc/refman/8.0/en/stored-program-restrictions.html
Event timings using the intervals YEAR, QUARTER, MONTH, and YEAR_MONTH are resolved in months; those using any other interval are resolved in seconds. (Bug #16422) Events do not support times later than the end of the Unix Epoch; this is ...Some of ...
https://dev.mysql.com/doc/refman/8.0/en/storage-requirements.html
InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-types.html
However, you can use other date and time functions that return an integer or NULL, such as WEEKDAY(), DAYOFYEAR(), or MONTH(). This section discusses the types of partitioning which are available in MySQL 8.0. This type of partitioning assigns rows ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html
The maximum and default value of rpl_stop_replica_timeout is 31536000 seconds (1 year). The maximum and default value of rpl_stop_slave_timeout is 31536000 seconds (1 year). This section explains the server options and system variables that apply ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
The default is 86400 seconds (24 hours), but the time period can be extended to as much as one year. The MySQL server maintains many system variables that affect its operation. Most system variables can be set at server startup using options on the ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-best-practices.html
LTS releases have 8+ years of support and are meant for production use. MySQL supports upgrading between minor versions (within an LTS series) and to the next major version (across an LTS series). Performing a minor version upgrade is ...
https://dev.mysql.com/doc/refman/8.0/en/using-date.html
This makes MySQL very convenient for Web applications where you obtain year, month, and day in three different fields and you want to store exactly what the user inserted (without date validation). You should use this format in UPDATE expressions ...