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/timestamp-initialization.html
CREATE TABLE t1 ( ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, dt DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ); With a DEFAULT clause but no ON UPDATE CURRENT_TIMESTAMP clause, the column has the given ...
https://dev.mysql.com/doc/refman/8.0/en/windows-symbolic-links.html
To do this, create a symbolic link in the MySQL data directory that points to D:\data\mydb. However, before creating the symbolic link, make sure that the D:\data\mydb directory exists by creating it if necessary. On Windows, you can create a ... On ...
https://dev.mysql.com/doc/refman/8.0/en/assigning-passwords.html
Operations that assign or modify passwords are permitted only to users with the CREATE USER privilege, or, alternatively, privileges for the mysql database (INSERT privilege to create new accounts, UPDATE privilege to modify existing accounts). If ... Required credentials for clients that connect to the MySQL server can include a ...
https://dev.mysql.com/doc/refman/8.0/en/alter-user.html
In most cases, ALTER USER requires the global CREATE USER privilege, or the UPDATE privilege for the mysql system schema. If an account is to be permitted to manipulate secondary passwords for all accounts, it requires the CREATE USER privilege ...
https://dev.mysql.com/doc/refman/8.0/en/change-master-to.html
When using a multithreaded replica (replica_parallel_workers > 0 or slave_parallel_workers > 0), stopping the replica can cause gaps in the sequence of transactions that have been executed from the relay log, regardless of whether the replica was ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-sets.html
For non-language-specific collations, characters in contraction sequences are treated as separate characters. For example, utf8mb4_unicode_ci works fine for German dictionary order and French, so there is no need to create special utf8mb4 collations. Miscellaneous Information The xxx_general_mysql500_ci collations preserve the pre-5.1.24 ordering of the original xxx_general_ci collations and permit upgrades for tables created before MySQL 5.1.24 (Bug ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-natural-language.html
To search the title or body separately, you would create separate FULLTEXT indexes for each column. The MySQL FULLTEXT implementation regards any sequence of true word characters (letters, digits, and underscores) as a word. That sequence may also ... By default or with the IN NATURAL LANGUAGE MODE modifier, the MATCH() function performs a natural language search for a string against a text ...
https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-comments.html
MySQL Server supports a variant of the -- comment style; the -- start-comment sequence is accepted as such, but must be followed by a whitespace character such as a space or newline. To keep this from happening, MySQL requires a whitespace character ... Standard SQL uses the C syntax /* this is a comment */ for comments, and MySQL Server supports this syntax as ...
https://dev.mysql.com/doc/refman/8.0/en/charset-gb18030.html
If an incoming sequence is illegal, an error or warning is returned. If an illegal sequence is used in CONVERT(), an error is returned. The character set determines the length of a sequence using the first 1 or 2 bytes. In MySQL, the gb18030 ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-rule-based-filtering.html
The log_filter_dragnet log filter component enables log filtering based on user-defined rules. To enable the log_filter_dragnet filter, first load the filter component, then modify the log_error_services value. The following example enables ...