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/mysql-tips.html
Suppose that an indexed string column c1 is compared to a numeric value using WHERE c1 = 2222. For such comparisons, the string value is converted to a number and the operands are compared numerically (see Section 12.3, “Type Conversion in ...
https://dev.mysql.com/doc/refman/5.7/en/index-btree-hash.html
The index also can be used for LIKE comparisons if the argument to LIKE is a constant string that does not start with a wildcard character. LIKE '%string%' and string is longer than three characters, MySQL uses the Turbo Boyer-Moore algorithm to ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-mysqld.html
row *************************** Id: 1 User: system user Host: db: Command: Daemon Time: 1 State: Waiting for event from ndbcluster Info: NULL Important To participate in an NDB Cluster, the mysqld process must be started with both the options ...The ...To be used with NDB Cluster, mysqld needs to be built with support for the NDB storage engine, as it is in the precompiled binaries available from ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-move-data.html
--character-sets-dir=name Command-Line Format --character-sets-dir=path Type String Default Value [none] Directory where character sets are. --connect-string Command-Line Format --connect-string=connection_string Type String Default Value [none] ...
https://dev.mysql.com/doc/refman/5.7/en/charset-metadata.html
Thus column names, database names, user names, version names, and most of the string results from SHOW are metadata. If character_set_results is set to NULL, no conversion is performed and the server returns metadata using its original character set ... Metadata is “the data about the data.” Anything that describes the database—as opposed to being the contents of the database—is ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-general-options.html
--debug=debug_options, -# debug_options Command-Line Format --debug[=debug_options] Type String Default Value d:t:o,/tmp/myisamchk.trace Write a debugging log. --defaults-group-suffix=str Command-Line Format --defaults-group-suffix=str Type String ... The options described in this section can be used for any type of table maintenance operation performed by ...
https://dev.mysql.com/doc/refman/5.7/en/server-status-variable-reference.html
The following table lists all status variables applicable within mysqld. The last column indicates whether the scope for each variable is Global, Session, or both. Please see the corresponding item descriptions for details on setting and using the ...
https://dev.mysql.com/doc/refman/5.7/en/charset-errors.html
Character (nonbinary) string values are converted from their character set to UTF-8. Binary string values are copied as is for bytes in the range 0x20 to 0x7E, and using \x hexadecimal encoding for bytes outside that range. If character_set_results ... This section describes how the MySQL server uses character sets for constructing error ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-processes.html
For an executable shipped with the NDB Cluster distribution, node_version shows the two-part MySQL NDB Cluster version string, such as 5.7.44-ndb-7.5.36 or 5.7.44-ndb-7.6.33, that it was compiled with. See Version strings used in NDB Cluster ...
https://dev.mysql.com/doc/refman/5.7/en/sql-prepared-statements.html
SQL syntax for prepared statements does not support multi-statements (that is, multiple statements within a single string separated by ; characters). Using prepared statements with placeholders for parameter values has the following benefits: Less ...