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-install-configuration.html
Each data node or SQL node requires a my.cnf file that provides two pieces of information: a connection string that tells the node where to find the management node, and a line telling the MySQL server on this host (the machine hosting the data ...
https://dev.mysql.com/doc/refman/5.7/en/mysqld-multi.html
--password=password Command-Line Format --password=string Type String Default Value [none] The password of the MySQL account to use when invoking mysqladmin. --user=user_name Command-Line Format --user=name Type String Default Value root The user ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-numeric.html
For unique IDs or other values that can be represented as either strings or numbers, prefer numeric columns to string columns. Since large numeric values can be stored in fewer bytes than the corresponding strings, it is faster and takes less ...If ...
https://dev.mysql.com/doc/refman/5.7/en/option-file-options.html
--defaults-group-suffix=str Command-Line Format --defaults-group-suffix=string Type String Default Value [none] Read not only the usual option groups, but also groups with the usual names and a suffix of str. --login-path=name Command-Line Format ...
https://dev.mysql.com/doc/refman/5.7/en/problems-with-alias.html
In the select list of a query, a quoted column alias can be specified using identifier or string quoting characters: SELECT 1 AS `one`, 2 AS 'two'; Elsewhere in the statement, quoted references to the alias must use identifier quoting or the ... An ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-differing-tables.html
Between any of the string types CHAR, VARCHAR, and TEXT, including conversions between different widths. Lossy conversion is handled by inserting only the first N characters of the string on the replica, where N is the width of the target column.
https://dev.mysql.com/doc/refman/5.7/en/show-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, ... SHOW {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index ...
https://dev.mysql.com/doc/refman/5.7/en/x-plugin-options-system-variables.html
If X Plugin is enabled, it exposes several system variables that permit control over its operation: mysqlx_bind_address Command-Line Format --mysqlx-bind-address=addr System Variable mysqlx_bind_address Scope Global Dynamic No Type String Default ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-disabling.html
The audit_log_disable variable can be set in a MySQL Server option file, in a command-line startup string, or at runtime using a SET statement; for example: SET GLOBAL audit_log_disable = true; Setting audit_log_disable to true disables the audit ...
https://dev.mysql.com/doc/refman/5.7/en/begin-end.html
END syntax is used for writing compound statements, which can appear within stored programs (stored procedures and functions, triggers, and events). Use of multiple statements requires that a client is able to send statement strings containing the ; ...A compound statement can contain multiple statements, enclosed by the BEGIN and END ...