Search Results
https://dev.mysql.com/doc/refman/8.4/en/subqueries.html
For information about how the optimizer handles subqueries, see Section 10.2.2, “Optimizing Subqueries, Derived Tables, View References, and Common Table Expressions”. All subquery forms and operations that the SQL standard requires are ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-materialization.html
Materialization speeds up query execution by generating a subquery result as a temporary table, normally in memory. The first time MySQL needs the subquery result, it materializes that result into a temporary table. Any subsequent time the result is ... The optimizer uses materialization to enable more efficient subquery ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-optimization-with-exists.html
row *************************** id: 2 select_type: DEPENDENT SUBQUERY table: t2 type: ref_or_null possible_keys: maybe_null_key key: maybe_null_key key_len: 5 ref: func rows: 2 Extra: Using where; Using index ... Triggered equalities can be used by ... Certain optimizations are applicable to comparisons that use the IN (or =ANY) operator to test subquery ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-using-a-recommendation-model-ratings-rankings.html
mysql> CALL sys.ML_MODEL_LOAD('recommendation_use_case', NULL); Make predictions for the test dataset by using the ML_PREDICT_TABLE routine. mysql> CALL sys.ML_PREDICT_TABLE(table_name, model_handle, output_table_name), [options]); Replace ... This ...
https://dev.mysql.com/doc/refman/8.4/en/webauthn-pluggable-authentication.html
Table 8.26 Plugin and Library Names for WebAuthn Authentication Plugin or File Plugin or File Name Server-side plugin authentication_webauthn Client-side plugin authentication_webauthn_client Library file authentication_webauthn.so, ... Note ...
https://dev.mysql.com/doc/refman/8.4/en/gis-point-property-functions.html
A Point consists of X and Y coordinates, which may be obtained using the ST_X() and ST_Y() functions, respectively. These functions also permit an optional second argument that specifies an X or Y coordinate value, in which case the function result ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-operator-functions.html
OpenGIS proposes a number of functions that can produce geometries. These functions support all argument type combinations except those that are inapplicable according to the Open Geospatial Consortium specification. MySQL also implements certain ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-building-clients.html
Also, target hosts running the client application must have the Visual C++ Redistributable for Visual Studio 2015 installed. This section provides guidelines for compiling C programs that use the MySQL C API. Compiling MySQL Clients on Unix ...
https://dev.mysql.com/doc/workbench/en/dbdoc-templates-custom.html
The copy can be given any suitable name; for example, Custom_Basic.tpl. This is done using a suitable command-line tool, and there are also free online tools that generate GUIDs. In the simplest case, a template consists of two files: a template ...
https://dev.mysql.com/doc/workbench/en/wb-migration-overview-steps.html
"Schema Name Mapping Method" options while migrating Microsoft SQL Server: Keep schemas as they are: Catalog.Schema.Table -> Schema.Table: This will create multiple databases, one per schema. Only one schema: Catalog.Schema.Table -> Catalog.Table: ... This example migrates a Microsoft SQL Server database to MySQL and includes an image for each ...