MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 561 to 570 of 573 total results

https://dev.mysql.com/doc/refman/5.7/en/tuning-trace-purging.html

Thus, if a statement contains substatements (such as invoking stored procedures, stored functions, or triggers), the topmost statement and substatements each generate one trace, but at the end of execution, the trace for only the last substatement ...A user who wants to see the trace of a different substatement can enable or disable tracing for the desired substatement, but this requires editing the routine code, which may not always be ...

13.7.3.4 UNINSTALL PLUGIN Statement

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

The server executes the plugin's deinitialization function and removes the row for the plugin from the mysql.plugin system table, so that subsequent server restarts do not load and initialize the plugin. UNINSTALL PLUGIN plugin_name This statement ...

13.2.9.3 UNION Clause

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

UNION queries with an aggregate function in an ORDER BY clause are rejected with an ER_AGGREGATE_ORDER_FOR_UNION error. [UNION [ALL | DISTINCT] SELECT ...] UNION combines the result from multiple SELECT statements into a single result set. Selected ...

13.2.11 UPDATE Statement

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

The mysql_info() C API function returns the number of rows that were matched and updated and the number of warnings that occurred during the UPDATE. UPDATE is a DML statement that modifies rows in a table. Single-table syntax: UPDATE [LOW_PRIORITY] ...

2.10.10 Upgrading MySQL with Directly-Downloaded RPM Packages

https://dev.mysql.com/doc/refman/5.7/en/updating-direct-rpms.html

mysql_upgrade also performs other functions; see Section 4.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables” for details. It is preferable to use the MySQL Yum repository or MySQL SLES Repository to upgrade MySQL on RPM-based platforms.

2.10.5 Upgrading MySQL with the MySQL Yum Repository

https://dev.mysql.com/doc/refman/5.7/en/updating-yum-repo.html

mysql_upgrade also performs other functions; see Section 4.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables” for details. For supported Yum-based platforms (see Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum ...

6.2.1 Account User Names and Passwords

https://dev.mysql.com/doc/refman/5.7/en/user-names.html

To enable connections when the user name or password contain non-ASCII characters, client applications should call the mysql_options() C API function with the MYSQL_SET_CHARSET_NAME option and appropriate character set name as arguments. MySQL ...

9.4 User-Defined Variables

https://dev.mysql.com/doc/refman/5.7/en/user-variables.html

You can store a value in a user-defined variable in one statement and refer to it later in another statement. This enables you to pass values from one statement to another. User variables are written as @var_name, where the variable name var_name ...

11.4.10 Using Spatial Indexes

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

The optimizer investigates whether available spatial indexes can be involved in the search for queries that use a function such as MBRContains() or MBRWithin() in the WHERE clause. The following query finds all objects that are in the given ...

23.5.3 Updatable and Insertable Views

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

Some views are updatable and references to them can be used to specify tables to be updated in data change statements. That is, you can use them in statements such as UPDATE, DELETE, or INSERT to update the contents of the underlying table. Derived ...

Displaying 561 to 570 of 573 total results