PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/charset-gb18030.html
Supports comparison between gb18030 strings, and between gb18030 strings and strings of other character sets. In MySQL, the gb18030 character set corresponds to the “Chinese National Standard GB 18030-2005: Information technology — Chinese ...
https://dev.mysql.com/doc/refman/5.7/en/column-indexes.html
Index Prefixes FULLTEXT Indexes Spatial Indexes Indexes in the MEMORY Storage Engine Index Prefixes With col_name(N) syntax in an index specification for a string column, you can create an index that uses only the first N characters of the column.
https://dev.mysql.com/doc/refman/5.7/en/comp-err.html
--charset=dir_name, -C dir_name Command-Line Format --charset Type String Default Value ../share/charsets The character set directory. --debug=debug_options, -# debug_options Command-Line Format --debug=options Type String Default Value ... comp_err ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-function-reference.html
Table 6.35 MySQL Enterprise Data Masking and De-Identification Functions Name Description gen_blacklist() Perform dictionary term replacement gen_dictionary_drop() Remove dictionary from registry gen_dictionary_load() Load dictionary into registry ...
https://dev.mysql.com/doc/refman/5.7/en/dba-dtrace-mysqld-ref.html
query-start(query, connectionid, database, user, host) query-done(status) query-start: Triggered after the query string has been received from the client. The single argument, query, is a string containing the full text of the original query. For ...
https://dev.mysql.com/doc/refman/5.7/en/error-message-elements.html
Error Message Elements When an error occurs, error information includes several elements: an error code, SQLSTATE value, and message string. SQLSTATE value: This value is a five-character string (for example, '42S02'). Message string: This string ...
https://dev.mysql.com/doc/refman/5.7/en/identifiers.html
mysql> SET sql_mode='ANSI_QUOTES'; mysql> CREATE TABLE "test" (col INT); Query OK, 0 rows affected (0.00 sec) The ANSI_QUOTES mode causes the server to interpret double-quoted strings as identifiers. Consequently, when this mode is enabled, string ... Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, tablespace, and other object names are known as ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-indexes.html
For comparisons between nonbinary string columns, both columns should use the same character set. Comparison of dissimilar columns (comparing a string column to a temporal or numeric column, for example) may prevent use of indexes if values cannot ... Indexes are used to find rows with specific column values ...
https://dev.mysql.com/doc/refman/5.7/en/security-guidelines.html
To prevent password recovery using rainbow tables, do not use these functions on a plain password; instead, choose some string to be used as a salt, and use hash(hash(password)+salt) values. That does not mean the combination needs to be a random ...
https://dev.mysql.com/doc/refman/5.7/en/set-password.html
SET PASSWORD [FOR user] = password_option password_option: { 'auth_string' | PASSWORD('auth_string') } The SET PASSWORD statement assigns a password to a MySQL user account. = PASSWORD('auth_string') syntax is deprecated in MySQL 5.7 and is removed ...For information about the conditions under which this occurs for the server logs and how to control it, see Section 6.1.2.3, “Passwords and ...