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/macos-installation-pkg.html
Figure 2.14 MySQL Package Installer Wizard: Introduction The MySQL community edition shows a copy of the relevant GNU General Public License. The package is located inside a disk image (.dmg) file that you first need to mount by double-clicking its ...
https://dev.mysql.com/doc/refman/5.7/en/mathematical-functions.html
The following example shows how rounding differs for exact and approximate values: mysql> SELECT ROUND(2.5), ROUND(25E-1); +------------+--------------+ | ROUND(2.5) | ROUND(25E-1) | +------------+--------------+ | 3 | 2 | ...ABS(X) Returns the ...
https://dev.mysql.com/doc/refman/5.7/en/migrating-from-year2.html
YEAR(2) column definitions for new tables produce warnings or errors: Before MySQL 5.7.5, YEAR(2) column definitions for new tables are converted (with an ER_INVALID_YEAR_COLUMN_LENGTH warning) to 4-digit YEAR columns: mysql> CREATE TABLE t1 (y ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-repair.html
In this case, you must use ALTER TABLE to increase the MAX_ROWS and AVG_ROW_LENGTH table option values: ALTER TABLE tbl_name MAX_ROWS=xxx AVG_ROW_LENGTH=yyy; If you do not know the current table option values, use SHOW CREATE TABLE. The discussion ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-other-options.html
To obtain information about the key distribution, use a myisamchk --description --verbose tbl_name command or the SHOW INDEX FROM tbl_name statement. (The first time you use this option to sort a table, it may be very slow.) To determine a table's ... myisamchk supports the following options for actions other than table checks and repairs: --analyze, -a Command-Line Format --analyze Analyze the distribution of key ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-table-info.html
To obtain a description of a MyISAM table or statistics about it, use the commands shown here. myisamchk -eis tbl_name Shows only the most important information from a table. (Packed corresponds to what SHOW TABLE STATUS reports as Dynamic.) ...The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-api-definition.html
The syntax for setting this parameter is shown here: HeartbeatThreadPriority = policy[, priority] policy: {FIFO | RR} When setting this parameter, you must specify a policy. The [mysqld] and [api] sections in the config.ini file define the behavior ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-disk-data-objects.html
Statements that create these files are shown later in this section. Each of these tasks can be accomplished using SQL statements in the mysql client or other MySQL client application, as shown in the example that follows. For example, if an NDB ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-general-info.html
You can see this format used in the mysql client, as shown here: $> mysql Welcome to the MySQL monitor. MySQL NDB Cluster uses the MySQL server with the NDB storage engine. Support for the NDB storage engine is not included in standard MySQL Server ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-first-start.html
Note The IP address shown for a given NDB Cluster SQL or other API node in the output of SHOW is the address used by the SQL or API node to connect to the cluster data nodes, and not to any management node. Starting the cluster is not very ...