PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/updating-yum-repo.html
For supported Yum-based platforms (see Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”, for a list), you can perform an in-place upgrade for MySQL (that is, replacing the old version and then running the new version ...
https://dev.mysql.com/doc/refman/5.7/en/insert.html
You can use REPLACE instead of INSERT to overwrite old rows. REPLACE is the counterpart to INSERT IGNORE in the treatment of new rows that contain unique key values that duplicate old rows: The new rows replace the old rows rather than being ...
https://dev.mysql.com/doc/refman/5.7/en/json.html
For example, the JSON_SET(), JSON_INSERT(), and JSON_REPLACE() functions each take a JSON document, plus one or more path/value pairs that describe where to modify the document and the values to use. Consider this document: mysql> SET @j = '["a", ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-authentication-system-variables.html
For example, {UA} is replaced with a user name such as "admin", whereas {UD} is replaced with a use full DN such as "uid=admin,ou=People,dc=example,dc=com". For example, {UA} is replaced with a user name such as "admin", whereas {UD} is replaced ...
https://dev.mysql.com/doc/refman/5.7/en/updating-direct-rpms.html
The latest versions of RPMs from Oracle, when installed using the standard package management tool (yum, dnf, or zypper), seamlessly upgrades and replaces the version of MySQL that comes with the operating system, and the package manager ... It is ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-formats.html
For example, the following statement generates one Query event, two TableRead events, and a TableInsert events: INSERT INTO t3 SELECT t1.* FROM t1 JOIN t2; Each TableXXX event contains <TABLE> and <DB> elements to identify the table to which the ...
https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html
Note Named time zones can be used only if the time zone information tables in the mysql database have been created and populated. Otherwise, use of a named time zone results in an error: mysql> SET time_zone = 'UTC'; ERROR 1298 (HY000): Unknown or ... This section describes the time zone settings maintained by MySQL, how to load the system tables required for named time support, how to stay current with time zone changes, and how to enable leap-second ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-example-data.html
Working with database tables and data in NDB Cluster is not much different from doing so in standard MySQL. One of these is to modify the table definition before importing it into the Cluster database. The easiest way to accomplish this is to do a ... Note The information in this section applies to NDB Cluster running on both Unix and Windows ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-what-is-new-7-6.html
NDB 7.6 adds two tables to the ndbinfo information database to provide information about cluster nodes; these tables are listed here: config_nodes: This table the node ID, process type, and host name for each node listed in an NDB cluster's ... New ...
https://dev.mysql.com/doc/refman/5.7/en/known-issues.html
Even if you use lower_case_table_names=2 (which enables MySQL to remember the case used for databases and table names), MySQL does not remember the case used for database names for the function DATABASE() or within the various logs (on ... This ...