PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/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 9.7. This type of partitioning assigns rows ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/en/partitioning-handling-nulls.html
Partitioning in MySQL does nothing to disallow NULL as the value of a partitioning expression, whether it is a column value or the value of a user-supplied expression. Even though it is permitted to use NULL as the value of an expression that must ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/json-search-functions.html
type is one of the following data types: FLOAT DOUBLE DECIMAL SIGNED UNSIGNED DATE TIME DATETIME YEAR YEAR values of one or two digits are not supported. The functions in this section perform search or comparison operations on JSON values to ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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 ...