MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 161 to 170 of 171 total results

https://dev.mysql.com/doc/refman/5.7/en/primary-key-optimization.html

These unique IDs can serve as pointers to corresponding rows in other tables when you join tables using foreign keys. The primary key for a table represents the column or set of columns that you use in your most vital queries. Query performance ...

16.1.3.2 GTID Life Cycle

https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-lifecycle.html

For example, you might need to do this after carrying out test queries to verify a replication setup on new GTID-enabled servers, or when you want to join a new server to a replication group but it contains some unwanted local transactions that are ... The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the replication source ...

6.1.7 Client Programming Security Guidelines

https://dev.mysql.com/doc/refman/5.7/en/secure-client-programming.html

It would be nearly impossible, for example, to debug a common 10-way join SELECT statement without providing information regarding which databases, tables, and other objects are involved with problems. Client applications that access MySQL should ...

13.7.5.22 SHOW INDEX Statement

https://dev.mysql.com/doc/refman/5.7/en/show-index.html

The higher the cardinality, the greater the chance that MySQL uses the index when doing joins. SHOW {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index information. This statement requires ...

8.2.2 Optimizing Subqueries, Derived Tables, and View References

https://dev.mysql.com/doc/refman/5.7/en/subquery-optimization.html

Note A limitation on UPDATE and DELETE statements that use a subquery to modify a single table is that the optimizer does not use semijoin or materialization subquery optimizations. As a workaround, try rewriting them as multiple-table UPDATE and ...

26.4.5.1 The extract_schema_from_file_name() Function

https://dev.mysql.com/doc/refman/5.7/en/sys-extract-schema-from-file-name.html

It provides a convenient way to display schema names, which can be more easily understood than full path names, and can be used in joins against object schema names. Given a file path name, returns the path component that represents the schema name. This function assumes that the file name lies within the schema ...

26.4.5.2 The extract_table_from_file_name() Function

https://dev.mysql.com/doc/refman/5.7/en/sys-extract-table-from-file-name.html

It provides a convenient way to display table names, which can be more easily understood than full path names, and can be used in joins against object table names. Given a file path name, returns the path component that represents the table name.

B.3.6.2 TEMPORARY Table Problems

https://dev.mysql.com/doc/refman/5.7/en/temporary-table-problems.html

Temporary tables created with CREATE TEMPORARY TABLE have the following limitations: TEMPORARY tables are supported only by the InnoDB, MEMORY, MyISAM, and MERGE storage engines. Use ALTER TABLE instead: ALTER TABLE old_name RENAME new_name; You ...

2.10.3 Changes in MySQL 5.7

https://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html

Before upgrading to MySQL 5.7, review the changes described in this section to identify those that apply to your current MySQL installation and applications. Changes marked as Incompatible change are incompatibilities with earlier versions of ...

23.5.1 View Syntax

https://dev.mysql.com/doc/refman/5.7/en/view-syntax.html

The CREATE VIEW statement creates a new view (see Section 13.1.21, “CREATE VIEW Statement”). To alter the definition of a view or drop a view, use ALTER VIEW (see Section 13.1.10, “ALTER VIEW Statement”), or DROP VIEW (see Section 13.1.32, ...

Displaying 161 to 170 of 171 total results