https://dev.mysql.com/calculating-days.html
The following example shows how you can use the bit group functions to calculate the number of days per month a user has visited a Web page. CREATE TABLE t1 (year YEAR(4), month INT UNSIGNED, day INT UNSIGNED); INSERT INTO t1 ...
https://dev.mysql.com/date-and-time-functions.html
The following query selects all rows with a date_col value from within the last 30 days: mysql> SELECT something FROM tbl_name -> WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= date_col; The query also selects rows with dates that lie in the future.
https://dev.mysql.com/expressions.html
unit represents the unit for interpreting the quantity; it is a specifier such as HOUR, DAY, or WEEK. For example, if you specify a unit of DAY_SECOND, the value of expr is expected to have days, hours, minutes, and seconds parts. If you specify a ... This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in ...
https://dev.mysql.com/create-user.html
CREATE USER 'jeffrey'@'localhost' PASSWORD EXPIRE NEVER; PASSWORD EXPIRE INTERVAL N DAY This expiration option overrides the global policy for all accounts named by the statement. CREATE USER 'jeffrey'@'localhost' PASSWORD REUSE INTERVAL DEFAULT; ...
https://dev.mysql.com/alter-user.html
ALTER USER 'jeffrey'@'localhost' PASSWORD EXPIRE NEVER; PASSWORD EXPIRE INTERVAL N DAY This expiration option overrides the global policy for all accounts named by the statement. ALTER USER 'jeffrey'@'localhost' PASSWORD REUSE INTERVAL DEFAULT; ...
https://dev.mysql.com/password-management.html
If the value of default_password_lifetime is a positive integer N, it indicates the permitted password lifetime, such that passwords must be changed every N days. Example account-specific statements: Require the password to be changed every 90 days: ... MySQL supports these password-management capabilities: Password expiration, to require passwords to be changed ...
https://dev.mysql.com/creating-ssl-files-using-openssl.html
This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and clients. The first example shows a simplified procedure such as you might use from the command line. The first two examples ...
https://dev.mysql.com/func-op-summary-ref.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/with.html
Each row produced by the recursive SELECT adds one day to the date produced by the previous row. The use of COALESCE() avoids displaying NULL in the sum_price column on days for which no sales data occur in the sales table. A common table ...
https://dev.mysql.com/date-and-time-types.html
Although MySQL tries to interpret values in several formats, date parts must always be given in year-month-day order (for example, '98-09-04'), rather than in the month-day-year or day-month-year orders commonly used elsewhere (for example, ... The ...
