PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/built-in-function-reference.html
8.0.18 WEEK() Return the week number WEEKDAY() Return the weekday index WEEKOFYEAR() Return the calendar week of the date (1-53) WEIGHT_STRING() Return the weight string for a string XOR Logical XOR YEAR() Return the year YEARWEEK() Return the year ... The following table lists each built-in (native) function and operator and provides a short description of each ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
default_password_lifetime Command-Line Format --default-password-lifetime=# System Variable default_password_lifetime Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 0 Minimum Value 0 Maximum Value 65535 Unit days This ...
https://dev.mysql.com/doc/refman/8.0/en/MySQLInstallerConsole.html
--catalog-update-days=int_value Accepts an integer between 1 (default) and 365 to indicate the number of days between checks for a new catalog update when MySQL Installer is started. Examples: MySQLIntallerConsole.exe set --reset-defaults ...
https://dev.mysql.com/doc/refman/8.0/en/create-event.html
For example, AT CURRENT_TIMESTAMP + INTERVAL 3 WEEK + INTERVAL 2 DAY is equivalent to “three weeks and two days from now”. This enables event execution to proceed as defined regardless of any subsequent changes to the server time zone or ...
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html
Check only that the month is in the range from 1 to 12 and the day is in the range from 1 to 31. This may be useful for Web applications that obtain year, month, and day in three different fields and store exactly what the user inserted, without ...
https://dev.mysql.com/doc/refman/8.0/en/using-date.html
If you enable the ALLOW_INVALID_DATES SQL mode, MySQL permits you to store dates that are given only limited checking: MySQL requires only that the day is in the range from 1 to 31 and the month is in the range from 1 to 12. This makes MySQL very ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-reference.html
audit_log_password_history_keep_days Command-Line Format --audit-log-password-history-keep-days=# Introduced 8.0.17 System Variable audit_log_password_history_keep_days Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 0 ...
https://dev.mysql.com/doc/refman/8.0/en/date-calculations.html
What if you want to know which animals have birthdays next month? For this type of calculation, year and day are irrelevant; you simply want to extract the month part of the birth column. MySQL provides several functions for extracting parts of ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html
The default binary log expiration period is 2592000 seconds, which equals 30 days (30*24*60*60 seconds). The default applies if neither binlog_expire_logs_seconds nor the deprecated system variable expire_logs_days has a value set at startup. If a ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-installer-catalog-dashboard.html
By default, and when an Internet connection is present, MySQL Installer attempts to update the catalog at startup every seven days. By default, MySQL Installer checks for catalog updates at startup every seven days. Use the product catalog option to ... This section describes the MySQL Installer product catalog, the dashboard, and other actions related to product selection and ...