PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-connection-strings.html
With the exception of the NDB Cluster management server (ndb_mgmd), each node that is part of an NDB Cluster requires a connection string that points to the management server's location. This connection string is used in establishing a connection ...This port should always be available on the network because it has been assigned by IANA for this purpose (see http://www.iana.org/assignments/port-numbers for ...
https://dev.mysql.com/doc/refman/5.7/en/load-data.html
\Z ASCII 26 (Control+Z) \N NULL For more information about \-escape syntax, see Section 9.1.1, “String Literals”. This differs from the word NULL enclosed within FIELDS ENCLOSED BY characters, which is read as the string 'NULL'. With fixed-row ...Input File Character Set The file name must be given as a literal ...The file can be read from the server ...
https://dev.mysql.com/doc/refman/5.7/en/string-collating.html
If the sorting rules for your language are too complex to be handled with simple arrays, you must define string collating functions in the ctype-MYSET.c source file in the strings directory. Look at the ctype-*.c files in the strings directory, such ... For a simple character set named MYSET, sorting rules are specified in the MYSET.xml configuration file using <map> array elements within <collation> ...
https://dev.mysql.com/doc/refman/5.7/en/string-types.html
The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. For information about storage requirements of the string data types, see Section 11.7, “Data Type Storage Requirements”. For descriptions of functions that ...
https://dev.mysql.com/doc/refman/5.7/en/comparison-operators.html
Table 12.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= Less than or equal operator <=> NULL-safe equal to operator = Equal operator BETWEEN ...
https://dev.mysql.com/doc/refman/5.7/en/encryption-functions.html
Note If you are using a KDF, you must specify an initialization vector or a null string for this argument, in order to access the later arguments to define the KDF. When you specify kdf_name, you must specify init_vector, using either a valid ...If ...N is 16 for an MD5() value and 20 for a SHA1() ...
https://dev.mysql.com/doc/refman/5.7/en/timestamp-initialization.html
In addition, if the explicit_defaults_for_timestamp system variable is disabled, you can initialize or update any TIMESTAMP (but not DATETIME) column to the current date and time by assigning it a NULL value, unless it has been defined with the NULL ... TIMESTAMP and DATETIME columns can be automatically initializated and updated to the current date and time (that is, the current ...
https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html
Returns NULL if any argument is NULL, or if the path argument does not identify a section of the target document. Returns NULL if any argument is NULL or no paths locate a value in the document. column->path In MySQL 5.7.9 and later, the -> operator ... The functions in this section perform search operations on JSON values to extract data from them, report whether data exists at a location within them, or report the path to data within ...
https://dev.mysql.com/doc/refman/5.7/en/glossary.html
Although the Oracle database allows a NULL value to be concatenated with a string, InnoDB treats the result of such an operation as NULL. It provides useful information for the query optimizer, because the column is known to be not null and with ...
https://dev.mysql.com/doc/refman/5.7/en/explain-output.html
The value can be NULL if the row refers to the union result of other rows. If this column is NULL (or undefined in JSON-formatted output), there are no relevant indexes. If key is NULL, MySQL found no index to use for executing the query more ...