MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 771 to 779 of 779 total results

« Previous
76
77
78
Next »

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 ...

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 ...

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 ...

1.2.1 What is MySQL?

https://dev.mysql.com/doc/refman/5.7/en/what-is-mysql.html

Although under constant development, MySQL Server today offers a rich and useful set of functions. MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle Corporation. The MySQL website ...

8.2.1.1 WHERE Clause Optimization

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

HAVING is merged with WHERE if you do not use GROUP BY or aggregate functions (COUNT(), MIN(), and so on). This section discusses optimizations that can be made for processing WHERE clauses. The examples use SELECT statements, but the same ...