PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/account-names.html
Quotes must be used if a user_name string contains special characters (such as space or -), or a host_name string contains special characters or wildcard characters (such as . Quote user names and host names as identifiers or as strings, using ...
https://dev.mysql.com/doc/refman/5.7/en/create-index.html
However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary string types (BINARY, ... CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ...
https://dev.mysql.com/doc/refman/5.7/en/hexadecimal-literals.html
To convert a string or a number to a string in hexadecimal format, use the HEX() function: mysql> SELECT HEX('cat'); +------------+ | HEX('cat') | +------------+ | 636174 | +------------+ mysql> SELECT X'636174'; +-----------+ | X'636174' | ...For ... Hexadecimal literal values are written using X'val' or 0xval notation, where val contains hexadecimal digits (0..9, ...
https://dev.mysql.com/doc/refman/5.7/en/charset-general.html
To use these features effectively, you must know what character sets and collations are available, how to change the defaults, and how they affect the behavior of string operators and functions. Suppose that we want to compare two string values, A ... A character set is a set of symbols and ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search-ngram.html
The full-text search syntax described in Section 12.9, “Full-Text Search Functions” applies to the ngram parser plugin. For example, with a token size of 2, the ngram parser parses the string “abc def” into four tokens: “ab”, “bc”, ... The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation when working with ideographic languages that do not use word ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-install-db.html
Note mysql_install_db is deprecated as of MySQL 5.7.6 because its functionality has been integrated into mysqld, the MySQL server. --admin-auth-plugin=plugin_name Command-Line Format --admin-auth-plugin=plugin_name Type String The authentication ...
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 ...