PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/date-and-time-literals.html
For example, '20070523' and '070523' are interpreted as '2007-05-23', but '071332' is illegal (it has nonsensical month and day parts) and becomes '0000-00-00'. For values specified as strings that include date part delimiters, it is unnecessary to ... Standard SQL and ODBC Date and Time Literals String and Numeric Literals in Date and Time Context Date and time values can be represented in several formats, such as quoted strings or as numbers, depending on the exact type of the value and other ...
https://dev.mysql.com/doc/refman/9.7/en/built-in-function-reference.html
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 and ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/en/audit-log-component-reference.html
audit_log.password_history_keep_days Command-Line Format --audit-log.password-history-keep-days=# System Variable audit_log.password_history_keep_days Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 0 Minimum Value 0 ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-reference.html
audit_log_password_history_keep_days Command-Line Format --audit-log-password-history-keep-days=# Deprecated Yes 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/9.7/en/information-schema-events-table.html
For example, if an event is created using ON SCHEDULE AT CURRENT_TIMESTAMP + '1:6' DAY_HOUR, and the event was created at 2018-02-09 14:05:30, the value shown in this column would be '2018-02-10 20:05:30'. The EVENTS table provides information ...