MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 321 to 330 of 334 total results

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

Status The plugin status, one of ACTIVE, INACTIVE, DISABLED, or DELETED. row *************************** Name: binlog Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL *************************** 2. row *************************** Name: ...

13.1.18.6 Silent Column Specification Changes

https://dev.mysql.com/doc/refman/5.7/en/silent-column-changes.html

Trailing spaces are automatically deleted from ENUM and SET member values when the table is created. In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE statement. These might be changes to ...

2.7.1 Installing MySQL on Solaris Using a Solaris PKG

https://dev.mysql.com/doc/refman/5.7/en/solaris-installation-pkg.html

Removal of the package does not delete the existing database information, only the server, binaries and support files. You can install MySQL on Solaris using a binary package of the native Solaris PKG format instead of the binary tarball ...

13.2.10.9 Subquery Errors

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

Incorrect number of rows from subquery: ERROR 1242 (ER_SUBSELECT_NO_1_ROW) SQLSTATE = 21000 Message = "Subquery returns more than 1 row" This error occurs for statements where the subquery must return at most one row but returns multiple rows.

13.2.10.12 Restrictions on Subqueries

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

For example, this limitation applies to statements of the following forms: DELETE FROM t WHERE ... In general, you cannot modify a table and select from the same table in a subquery. FROM t ...); Exception: The preceding prohibition does not apply ...

26.4.4.13 The ps_setup_reset_to_default() Procedure

https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-reset-to-default.html

row *************************** status: Resetting: setup_actors DELETE FROM performance_schema.setup_actors WHERE NOT (HOST = '%' AND USER = '%' AND ROLE = '%') *************************** 1. Parameters in_verbose BOOLEAN: Whether to display ...

23.3 Using Triggers

https://dev.mysql.com/doc/refman/5.7/en/triggers.html

A trigger is defined to activate when a statement inserts, updates, or deletes rows in the associated table. A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the table. Some ...

13.7.3.4 UNINSTALL PLUGIN Statement

https://dev.mysql.com/doc/refman/5.7/en/uninstall-plugin.html

It requires the DELETE privilege for the mysql.plugin system table because it removes the row from that table that registers the plugin. UNINSTALL PLUGIN plugin_name This statement removes an installed server plugin. plugin_name must be the name of ...

4.10 Unix Signal Handling in MySQL

https://dev.mysql.com/doc/refman/5.7/en/unix-signal-response.html

On Unix and Unix-like systems, a process can be the recipient of signals sent to it by the root system account or the system account that owns the process. Some command interpreters associate certain key sequences with signals, such as Control+C to ...

8.8.1 Optimizing Queries with EXPLAIN

https://dev.mysql.com/doc/refman/5.7/en/using-explain.html

The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. When EXPLAIN is used with an explainable statement, MySQL displays information from the ...

Displaying 321 to 330 of 334 total results