Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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.7/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/9.7/en/pluggable-authentication.html
When a client connects to the MySQL server, the server uses the user name provided by the client and the client host to select the appropriate account row from the mysql.user system table. Pluggable authentication makes it possible for clients to ...The server then authenticates the client, determining from the account row which authentication plugin applies to the client: If the server cannot find the plugin, an error occurs and the connection attempt is ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-functions.html
For this reason, if you select from the replica's copy of mytable after the CREATE TABLE and INSERT statements just shown have been replicated, you might expect mycol to contain the value 2009-09-01 18:00:00. Therefore, these functions should not be ... Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and LOAD_FILE() functions are replicated without change and thus do not work reliably on the replica unless row-based replication is ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-usagenotes-functionality-catalog-schema.html
Generally, catalogs are collections of schemas, so the fully qualified name would look like catalog.schema.table.column. In ODBC both schemas and catalogs can be used when referring to database objects such as tables. As a result the client software ... Many relational databases reference CATALOG and SCHEMA in ways that do not directly correspond to what MySQL refers to as a ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-functionality-catalog-schema.html
Generally, catalogs are collections of schemas, so the fully qualified name would look like catalog.schema.table.column. In ODBC both schemas and catalogs can be used when referring to database objects such as tables. As a result the client software ... Many relational databases reference CATALOG and SCHEMA in ways that do not directly correspond to what MySQL refers to as a ...
https://dev.mysql.com/doc/heatwave-aws/en/mysql-server-default-privileges.html
Default MySQL Privileges 3.1.2.9 Default MySQL Privileges This section lists the MySQL privileges granted to the MySQL Administrator user on the DB System and those explicitly revoked on the mysql and sys schemas.
https://dev.mysql.com/doc/refman/9.7/en/date-and-time-functions.html
mysql> SELECT CONVERT_TZ('2004-01-01 12:00:00','GMT','MET'); -> '2004-01-01 13:00:00' mysql> SELECT CONVERT_TZ('2004-01-01 12:00:00','+00:00','+10:00'); -> '2004-01-01 22:00:00' Note To use named time zones such as 'MET' or 'Europe/Amsterdam', the ... This section describes the functions that can be used to manipulate temporal ...