Search Results
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-23-u1.html
Functionality Added or Changed String column encoding support was added for TEXT-type columns. The following temporal functions are now supported with VARLEN-encoded columns: TO_DAYS() DAYOFYEAR() QUARTER() TO_SECONDS() See Temporal Functions. The ...The clauses are now supported at any location in a query that is permitted by ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-usage.html
When the plugin reads each rule from the rules table, it computes a normalized (statement digest) form from the pattern and a digest hash value, and uses them to update the normalized_pattern and pattern_digest columns: mysql> SELECT * FROM ... To ...
https://dev.mysql.com/doc/relnotes/connector-odbc/en/news-8-0-33.html
(WL #15482) Improved JSON data character support by presenting JSON columns as utf8mb4 strings instead of binary data. This change also affected the following ODBC functions: SQLColumns() result set changes: DATA_TYPE (column #5) and SQL_DATA_TYPE ... Functionality Added or Changed Bugs Fixed Functionality Added or Changed Added a new OCI_CONFIG_PROFILE connection option to define a profile set in OCI_CONFIG_FILE; and it defaults to ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-31.html
A new column notes has been added to the MODEL_CATALOG table, which you can use to record notes about the models in your model catalog. The new column model_metadata in the MODEL_CATALOG table records metadata for models, such as the training score, ... MySQL HeatWave AutoML Functionality Added or Changed MySQL HeatWave AutoML MySQL HeatWave AutoML queries are now monitored and recorded in the Performance Schema tables rpd_query_stats and ...
https://dev.mysql.com/doc/internals/en/load-data-infile-events.html
LOAD DATA INFILE is not written to the binary log like other statements. It is written as one or more events in a packed format, not as a cleartext statement in the binary log. The events indicate what options are present in the statement and how ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utils-copy.html
The utilities convert columns with data types that are not safe to be stored in text form (such as BLOB) to Base64. The size of these columns therefore must not exceed approximately 0.74 times the value of the max_allowed_packet system variable (in ... This section describes the MySQL Shell copy utilities: About the Utilities Requirements and Restrictions Running the Utilities Options for Copy Control Options for Filtering Examples About the Utilities The copy utilities enable you to copy DDL and data between MySQL instances, without the need for intermediate ...
https://dev.mysql.com/doc/workbench/en/wb-develop-sql-editor-results.html
Figure 8.4 SQL Editor - Result Grid Result Grid Toolbar Elements of the result grid toolbar include: Reset: Resets all sorted columns. Note The "Refresh" button automatically adjusts the column width to match the longest string one of its cells.
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-qanal-config-ui.html
Figure 32.8 Graph View Filter View Figure 32.9 Filter View The following are the possible filter options: Column: enables you to filter the queries based on specific values within any of the columns shown in the Query Analyzer report list. To use ...
https://dev.mysql.com/doc/refman/8.4/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. Most of the reserved words in the list are forbidden by standard SQL as column or table names (for ...This may also be true for the names of built-in ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-62.html
Figure 1.13 Geometry Data Viewer Additional New SQL Editor Features Result Set Widths: resized result set column widths are now preserved and remembered. This data is saved under Workbench's cache/ directory using the schema.table.column format.