Search Results
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-hwaml-create-model.html
MySQL HeatWave AutoML uses the selected algorithms as a pool of algorithms, and will choose the most applicable algorithm from this pool to evaluate the model. To use a single, specific algorithm to evaluate the model, deselect all the other ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-update-monitoring-configuration.html
To update the CloudWatch Monitoring configuration for a DB System follow these steps: In the MySQL HeatWave Console, select the Resources tab. In the Update Monitoring Configuration pane: Select Enable CloudWatch Monitoring if you want to use ...
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-implementation-notes.html
You must use a column alias with the value of the column to the actual name of the BLOB, for example: SELECT id, 'data' as blob_data from blobtable You must also follow these rules: The SELECT must reference only one table. The SELECT must alias the ... MySQL Connector/J, as a rigorous implementation of the JDBC API, passes all of the tests in the publicly available version of Oracle's JDBC compliance test ...
https://dev.mysql.com/doc/refman/8.4/en/case-sensitivity.html
This example shows that VERSION() returns a string that has a case-insensitive collation, so comparisons are case-insensitive: mysql> SELECT COLLATION(VERSION()); +----------------------+ | COLLATION(VERSION()) | +----------------------+ | ... For ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-sets.html
For example: mysql> SELECT COLLATION_NAME, PAD_ATTRIBUTE FROM INFORMATION_SCHEMA.COLLATIONS WHERE CHARACTER_SET_NAME = 'utf8mb4'; +----------------------------+---------------+ | COLLATION_NAME | PAD_ATTRIBUTE | ... This section describes the ...
https://dev.mysql.com/doc/refman/8.4/en/comments.html
For example, MySQL Server recognizes the STRAIGHT_JOIN keyword in the following statement, but other servers should not: SELECT /*! STRAIGHT_JOIN */ col1 FROM table1,table2 WHERE ... MySQL Server supports three comment styles: From a # character to ...
https://dev.mysql.com/doc/refman/8.4/en/condition-filtering.html
To the extent that the optimizer can use information about conditions on rows selected from one table and passed to the next, the more accurately it can compute row estimates and choose the best execution plan. Without condition filtering, the ...
https://dev.mysql.com/doc/refman/8.4/en/create-event.html
You may not use stored functions or loadable functions in such expressions, nor may you use any table references; however, you may use SELECT FROM DUAL. Note Statements such as SELECT or SHOW that merely return a result set have no effect when used ... CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON {REPLICA | SLAVE}] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-security.html
MySQL connectors and clients select the highest TLS version available by default. Where can I find documentation that addresses security issues for MySQL? A.9.2. Is SSL support built into MySQL binaries, or must I recompile the binary myself to ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-stored-procs.html
For a database named dbname, use this query on the INFORMATION_SCHEMA.ROUTINES table: SELECT ROUTINE_TYPE, ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA='dbname'; For more information, see Section 28.3.30, “The ...Where can I ...