PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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/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/rewriter-query-rewrite-plugin-reference.html
pattern_database The database used to match unqualified table names in statements. Qualified table names in statements match qualified names in the pattern if corresponding database and table names are identical. Unqualified table names in ...Users ...
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/linux-installation-yum-repo.html
Before You Start As a popular, open-source software, MySQL, in its original or re-packaged form, is widely installed on many systems from various sources, including different software download sites, software repositories, and so on. Steps for a ...
https://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html
The Performance Schema tables are intended to replace the INFORMATION_SCHEMA tables, which are deprecated as of MySQL 5.7.6 and are removed in MySQL 8.0. In MySQL 5.7.9, DYNAMIC replaces COMPACT as the implicit default row format for InnoDB tables.
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 ...
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 ...