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/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-ndbinfo.html
ndbinfo is a database containing information specific to NDB Cluster. This database contains a number of tables, each providing a different sort of data about NDB Cluster node status, resource usage, and operations. This is true even when using the ...You can find more detailed information about each of these tables in the next several ...
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/xml-functions.html
Table 12.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section discusses XML and related functionality in MySQL. See Section 4.5.1, “mysql ...
https://dev.mysql.com/doc/refman/5.7/en/getting-information.html
What if you forget the name of a database or table, or what the structure of a given table is (for example, what its columns are called)? MySQL addresses this problem through several statements that provide information about the databases and ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-copying-to-other-server.html
On Server 1: $> mysqldump --databases db1 > dump.sql Copy the dump file from Server 1 to Server 2. On Server 2: $> mysql < dump.sql Use of --databases with the mysqldump command line causes the dump file to include CREATE DATABASE and USE ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-partitioning.html
There may be situations where you have a single source and want to replicate different databases to different replicas. A sample of this layout is shown in Figure 16.2, “Replicating Databases to Separate Replicas”. Figure 16.2 Replicating ...
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/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/information-functions.html
DATABASE() Returns the default (current) database name as a string in the utf8 character set. Within a stored routine, the default database is the database that the routine is associated with, which is not necessarily the same as the database that ...It may be used to time how quickly MySQL processes the ...