Search Results
https://dev.mysql.com/doc/refman/9.7/en/spatial-index-optimization.html
MySQL still maintains such indexes, as follows: They are updated for table modifications (INSERT, UPDATE, DELETE, and so forth). MySQL permits creation of SPATIAL indexes on NOT NULL geometry-valued columns (see Section 13.4.10, “Creating Spatial ...
https://dev.mysql.com/doc/refman/9.7/en/stored-routines.html
In such a setup, applications and users would have no access to the database tables directly, but can only execute specific stored routines. A stored routine is a set of SQL statements that can be stored in the server. Once this has been done, ...
https://dev.mysql.com/doc/refman/9.7/en/tutorial.html
If you are interested only in accessing an existing database, you may want to skip the sections that describe how to create the database and the tables it contains. This chapter provides a tutorial introduction to MySQL by showing how to use the ...
https://dev.mysql.com/doc/refman/9.7/en/window-function-optimization.html
Window functions affect the strategies the optimizer considers: Derived table merging for a subquery is disabled if the subquery has window functions. Semijoins are not applicable to window function optimization because semijoins apply to ...
https://dev.mysql.com/doc/connector-cpp/9.7/en/connector-cpp-source-configuration-options.html
On non-Windows systems, CMake checks to see whether MYSQL_CONFIG_EXECUTABLE is set. -DBUNDLE_DEPENDENCIES=bool This is an internal option used for creating Connector/C++ distribution packages. -DCMAKE_BUILD_TYPE=type The type of build to produce: ...
https://dev.mysql.com/doc/mysql-router/9.7/en/mysql-router-installation-docker.html
The Docker deployment framework supports easy installation and configuration of MySQL Router. This section explains how to use a MySQL Router Docker image. You need to have Docker installed on your system before you can use a MySQL Router Docker ...
https://dev.mysql.com/doc/c-api/9.7/en/c-api-prepared-statement-interface.html
Metadata changes to tables or views referred to by prepared statements are detected and cause automatic repreparation of the statement when it is next executed. The MySQL client/server protocol provides for the use of prepared statements. This ...
https://dev.mysql.com/doc/c-api/9.7/en/c-api-prepared-statement-type-conversions.html
Metadata changes to tables or views referred to by prepared statements are detected and cause automatic repreparation of the statement when it is next executed. Prepared statements transmit data between the client and server using C language ...
https://dev.mysql.com/doc/c-api/9.7/en/mysql-select-db.html
In subsequent queries, this database is the default for table references that include no explicit database specifier. int mysql_select_db(MYSQL *mysql, const char *db) Description Causes the database specified by db to become the default (current) ...
https://dev.mysql.com/doc/extending-mysql/9.7/en/writing-daemon-plugins.html
To verify plugin installation, examine the INFORMATION_SCHEMA.PLUGINS table or use the SHOW PLUGINS statement. A daemon plugin is a simple type of plugin used for code that should be run by the server but that does not communicate with it. This ...