PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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. Instead, use SHA2() or some other one-way hashing function ... Anyone using MySQL on a computer connected to the Internet should read this section to avoid the most common security ...
https://dev.mysql.com/doc/refman/5.7/en/bit-value-literals.html
For example, a bit literal assigned to a user-defined variable is a binary string by default. To convert a bit value to printable form, use it in numeric context or use a conversion function such as BIN() or HEX(). A leading 0b is case-sensitive and ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-information-schema.html
String columns in INFORMATION_SCHEMA tables have a collation of utf8_general_ci, which is case-insensitive. However, for values that correspond to objects that are represented in the file system, such as databases and tables, searches in ...For ...
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/date-and-time-type-syntax.html
MySQL displays DATE values in 'YYYY-MM-DD' format, but permits assignment of values to DATE columns using either strings or numbers. MySQL displays DATETIME values in 'YYYY-MM-DD hh:mm:ss[.fraction]' format, but permits assignment of values to ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-mgm-client-commands.html
CONNECT connection-string Connects to the management server indicated by the connection string. PROMPT [prompt] Changes the prompt shown by ndb_mgm to the string literal prompt. mgm#1: PROMPT mymgm > mymgm > PROMPT 'mymgm:' 'mymgm:' PROMPT mymgm: ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-reference.html
These procedures invoke administrative functions that provide an API for lower-level tasks. The procedure uses firewall administrative functions to reload the in-memory rules for an account profile from the rules stored in the ...When enabled, the ...
https://dev.mysql.com/doc/refman/5.7/en/character-arrays.html
For a complex character set as implemented in a ctype-MYSET.c file in the strings directory, there are corresponding arrays: ctype_MYSET[], to_lower_MYSET[], and so forth. See the CHARSET_INFO.txt file in the strings directory for additional ...
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 ...