PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/expired-password-handling.html
For example: ALTER USER 'myuser'@'localhost' PASSWORD EXPIRE; For each connection that uses an account with an expired password, the server either disconnects the client or restricts the client to “sandbox mode,” in which the server permits the ... MySQL provides password-expiration capability, which enables database administrators to require that users reset their ...
https://dev.mysql.com/doc/refman/8.0/en/using-date.html
You should use this format in UPDATE expressions and in the WHERE clause of SELECT statements. MySQL also permits a “relaxed” string format when updating and in a WHERE clause that compares a date to a DATE, DATETIME, or TIMESTAMP column. To be ...For example: SELECT * FROM t1 WHERE date >= '2003-05-05'; As a convenience, MySQL automatically converts a date to a number if the date is used in numeric context and vice ...
https://dev.mysql.com/doc/refman/8.0/en/load-data.html
When IGNORE—or LOCAL without REPLACE—is specified, data interpretation errors become warnings and the load operation continues, even if the SQL mode is restrictive. Interpretation of field values and assignment to table columns depends on these ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-legacy-filtering.html
Legacy Mode Audit Log Filtering is deprecated as of MySQL 8.0.34. Note The audit_log_policy legacy-mode system variable is deprecated as of MySQL 8.0.34. Note This section describes legacy audit log filtering, which applies if the audit_log plugin ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-background.html
The group can operate in a single-primary mode with automatic primary election, where only one server accepts updates at a time. Alternatively, for more advanced users the group can be deployed in multi-primary mode, where all servers can accept ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-types.html
The TIMESTAMP and DATETIME types have special automatic updating behavior, described in Section 13.2.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”. By setting the SQL mode to the appropriate value, you can specify more ...
https://dev.mysql.com/doc/refman/8.0/en/char.html
When CHAR values are retrieved, trailing spaces are removed unless the PAD_CHAR_TO_FULL_LENGTH SQL mode is enabled. If strict SQL mode is not enabled and you assign a value to a CHAR or VARCHAR column that exceeds the column's maximum length, the ...
https://dev.mysql.com/doc/refman/8.0/en/connecting-using-uri-or-key-value-pairs.html
The following options are available: ssl-mode: The desired security state for the connection. The following modes are permissible: DISABLED PREFERRED REQUIRED VERIFY_CA VERIFY_IDENTITY Important VERIFY_CA and VERIFY_IDENTITY are better choices than ... This section describes use of URI-like connection strings or key-value pairs to specify how to establish connections to the MySQL server, for clients such as MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-natural-language.html
By default or with the IN NATURAL LANGUAGE MODE modifier, the MATCH() function performs a natural language search for a string against a text collection. MyISAM Limitation For very small tables, word distribution does not adequately reflect their ...A collection is a set of one or more columns included in a FULLTEXT ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tables-table.html
Even with file-per-table mode with each InnoDB table in a separate .ibd file, change buffering can delay the write to the data file, so the file modification time is different from the time of the last insert, update, or delete. To update cached ...