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/extensions-to-ansi.html
RENAME and let the server rename the files.) General language syntax By default, strings can be enclosed by " as well as '. If the ANSI_QUOTES SQL mode is enabled, strings can be enclosed only by ' and the server interprets strings enclosed by " as ... MySQL Server supports some extensions that are likely not to be found in other SQL ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-tuning.html
When to Use Compression In general, compression works best on tables that include a reasonable number of character string columns and where the data is read far more often than it is written. Recall that compression works by identifying repeated ...
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/mysql-cluster-programs-ndb-mgmd.html
--connect-string Command-Line Format --connect-string=connection_string Type String Default Value [none] Same as --ndb-connectstring. --defaults-extra-file Command-Line Format --defaults-extra-file=path Type String Default Value [none] Read given ...
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/charset-binary-collations.html
This section describes how the binary collation for binary strings compares to _bin collations for nonbinary strings. Binary strings (as stored using the BINARY, VARBINARY, and BLOB data types) have a character set and collation named binary. A ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html
--debug[=debug_options], -# [debug_options] Command-Line Format --debug[=debug_options] Type String Default Value d:t:O,/tmp/mysqlpump.trace Write a debugging log. --default-auth=plugin Command-Line Format --default-auth=plugin Type String A hint ...
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 ...