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/information-schema-innodb-sys-foreign-table.html
The INNODB_SYS_FOREIGN table has these columns: ID The name (not a numeric value) of the foreign key index, preceded by the schema (database) name (for example, test/products_fk). The INNODB_SYS_FOREIGN table provides metadata about InnoDB foreign ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-foreign-key.html
Foreign keys let you cross-reference related data across tables, and foreign key constraints help keep this spread-out data consistent. MySQL supports ON UPDATE and ON DELETE foreign key references in CREATE TABLE and ALTER TABLE statements. The ...
https://dev.mysql.com/doc/refman/5.7/en/counting-rows.html
The use of COUNT() in conjunction with GROUP BY is useful for characterizing your data under various groupings. The following examples show different ways to perform animal census operations. See Section 12.19.1, “Aggregate Function ...Counting ...
https://dev.mysql.com/doc/refman/5.7/en/join.html
Generally, the ON clause serves for conditions that specify how to join tables, and the WHERE clause restricts which rows to include in the result set. If there is no matching row for the right table in the ON or USING part in a LEFT JOIN, a row ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-disk-data-objects.html
You can obtain information about data files used by Disk Data tables by querying the FILES table in the INFORMATION_SCHEMA database. These include the following: Tablespaces act as containers for other Disk Data objects. For example, you cannot have ... NDB Cluster Disk Data storage is implemented using a number of Disk Data ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-diffengines.html
Configuring different engines on the source and replica depends on how you set up the initial replication process: If you used mysqldump to create the database snapshot on your source, you could edit the dump file text to change the engine type used ... It does not matter for the replication process whether the source table on the source and the replicated table on the replica use different engine ...
https://dev.mysql.com/doc/refman/5.7/en/archive-storage-engine.html
When you create an ARCHIVE table, the server creates a table format file in the database directory. The ARCHIVE engine also supports the AUTO_INCREMENT table option in CREATE TABLE statements to specify the initial sequence value for a new table or ...To examine the source for the ARCHIVE engine, look in the storage/archive directory of a MySQL source ... The ARCHIVE storage ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-upgrade-testing.html
(This is also useful for testing downgrades.) On the production server: $> mysqldump --all-databases --no-data --routines --events > dump-defs.sql On the upgraded server: $> mysql < dump-defs.sql Because the dump file does not contain table data, it ...Then you can dump the database and database object definitions from the production server and load them into the new server to verify that they are handled ...
https://dev.mysql.com/doc/refman/5.7/en/tutorial.html
(If you are the administrator, you need to consult the relevant portions of this manual, such as Chapter 5, MySQL Server Administration.) This chapter describes the entire process of setting up and using a database. This chapter provides a tutorial ...mysql (sometimes referred to as the “terminal monitor” or just “monitor”) is an interactive program that enables you to connect to a MySQL server, run queries, and view the ...
https://dev.mysql.com/doc/refman/5.7/en/any-in-some-subqueries.html
When used with a subquery, the word IN is an alias for = ANY. NOT IN is not an alias for <> ANY, but for <> ALL. The expression is TRUE if table t2 contains (21,14,7) because there is a value 7 in t2 that is less than 10. The expression is FALSE if ...