MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 61 to 70 of 77 total results

15.3.3 Statements That Cause an Implicit Commit

https://dev.mysql.com/doc/refman/9.7/en/implicit-commit.html

The statements listed in this section (and any synonyms for them) implicitly end any transaction active in the current session, as if you had done a COMMIT before executing the statement. Most of these statements also cause an implicit commit after ...

8.4.5.8 Using the keyring_aws Amazon Web Services Keyring Plugin

https://dev.mysql.com/doc/refman/9.7/en/keyring-aws-plugin.html

Note The keyring_aws plugin is an extension included in MySQL Enterprise Edition, a commercial product. Important The keyring_aws keyring plugin is deprecated, and is being replaced by the AWS Keyring component (component_aws_keyring). Deprecation ...

15.2.13.2 JOIN Clause

https://dev.mysql.com/doc/refman/9.7/en/join.html

MySQL supports the following JOIN syntax for the table_references part of SELECT statements and multiple-table DELETE and UPDATE statements: table_references: escaped_table_reference [, escaped_table_reference] ... index_hint: { USE {INDEX|KEY} ...

17.22 InnoDB Restrictions and Limitations

https://dev.mysql.com/doc/refman/9.7/en/innodb-restrictions-limitations.html

This section describes restrictions and limitations of the InnoDB storage engine. You cannot create a table with a column name that matches the name of an internal InnoDB column (including DB_ROW_ID, DB_TRX_ID, and DB_ROLL_PTR. This restriction ...

14.19.1 Aggregate Function Descriptions

https://dev.mysql.com/doc/refman/9.7/en/aggregate-functions.html

This section describes aggregate functions that operate on sets of values. They are often used with a GROUP BY clause to group values into subsets. If you use an aggregate function in a statement containing no GROUP BY clause, it is equivalent to ...

17.8.9 Purge Configuration

https://dev.mysql.com/doc/refman/9.7/en/innodb-purge-configuration.html

InnoDB does not physically remove a row from the database immediately when you delete it with an SQL statement. A row and its index records are only physically removed when InnoDB discards the undo log record written for the deletion. This removal ...

17.8.10.1 Configuring Persistent Optimizer Statistics Parameters

https://dev.mysql.com/doc/refman/9.7/en/innodb-persistent-stats.html

The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given query.

17.12.8 Online DDL Limitations

https://dev.mysql.com/doc/refman/9.7/en/innodb-online-ddl-limitations.html

The following limitations apply to online DDL operations: The table is copied when creating an index on a TEMPORARY TABLE. The ALTER TABLE clause LOCK=NONE is not permitted if there are ON...CASCADE or ON...SET NULL constraints on the table. Before ...

28.3.53 The INFORMATION_SCHEMA VIEWS Table

https://dev.mysql.com/doc/refman/9.7/en/information-schema-views-table.html

You must have the SHOW VIEW privilege to access this table. The VIEWS table has these columns: TABLE_CATALOG The name of the catalog to which the view belongs. TABLE_SCHEMA The name of the schema (database) to which the view belongs. VIEW_DEFINITION ...

15.6.4.2 Local Variable Scope and Resolution

https://dev.mysql.com/doc/refman/9.7/en/local-variable-scope.html

The scope of a local variable is the BEGIN ... The variable can be referred to in blocks nested within the declaring block, except those blocks that declare a variable with the same name. Because local variables are in scope only during stored ...

Displaying 61 to 70 of 77 total results