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/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, month INT UNSIGNED, day INT UNSIGNED); INSERT INTO t1 ...
https://dev.mysql.com/doc/refman/9.7/en/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/doc/refman/9.7/en/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/doc/refman/9.7/en/mysql-cluster-programs-ndb-sign-keys.html
--CA-days Command-Line Format --CA-days=# Type Integer Default Value 1461 Minimum Value -1 Maximum Value 2147483647 Set the lifetime of the certificate to this many days. --replace-by Command-Line Format --replace-by=# Type Integer Default Value -10 ... Management of TLS keys and certificates in implemented in NDB Cluster as the executable utility program ndb_sign_keys, which can normally be found in the MySQL bin ...
https://dev.mysql.com/doc/refman/9.7/en/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/doc/refman/9.7/en/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/doc/refman/9.7/en/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/doc/refman/9.7/en/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/doc/refman/9.7/en/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 ...
https://dev.mysql.com/doc/refman/9.7/en/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 ...