Search Results
https://dev.mysql.com/doc/refman/8.4/en/column-indexes.html
For example: CREATE TABLE test (blob_col BLOB, INDEX(blob_col(10))); Prefixes can be up to 767 bytes long for InnoDB tables that use the REDUNDANT or COMPACT row format. Note Prefix limits are measured in bytes, whereas the prefix length in CREATE ...The maximum number of indexes per table and the maximum index length is defined per storage ... The most common type of index involves a single column, storing copies of the values from that ...
https://dev.mysql.com/doc/refman/8.4/en/ddl-rewriter.html
MySQL 8.4 includes a ddl_rewriter plugin that modifies CREATE TABLE statements received by the server before it parses and executes them. The plugin removes ENCRYPTION, DATA DIRECTORY, and INDEX DIRECTORY clauses, which may be helpful when ...For ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-change-propagation.html
After tables are loaded into MySQL HeatWave, data changes are automatically propagated from DB System tables to their counterpart tables in the MySQL HeatWave Cluster. As of MySQL 9.2.1, TRANSACTIONAL indicates that change propagation is enabled ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-predict-row.html
A table can include extra columns, and still use the MySQL HeatWave AutoML model. This allows side by side comparisons of target column labels, ground truth, and predictions in the same table. The column names must match the feature column names in ... ML_PREDICT_ROW generates predictions for one or more rows of unlabeled data specified in JSON ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-nl-sql.html
You can use this routine for generating and running SQL queries only for databases and tables that you have access to. @output: output parameter that includes the list of tables and databases considered for generating the SQL query, Model ID of the ...The routine also runs the generated SQL statement and displays the result ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-mysqlai-ml-predict-row.html
A table can include extra columns, and still use the AutoML model. This allows side by side comparisons of target column labels, ground truth, and predictions in the same table. The column names must match the feature column names in the table used ... ML_PREDICT_ROW generates predictions for one or more rows of unlabeled data specified in JSON ...
https://dev.mysql.com/doc/refman/8.4/en/account-categories.html
For example, the CREATE USER privilege enables not only creation of new accounts, but modification and removal of existing accounts. Without the system user concept, a user who has the CREATE USER privilege can modify or drop any existing account, ... MySQL incorporates the concept of user account categories, based on the SYSTEM_USER ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-63.html
The premise is to use a generated script on the source server to create a dump that you move to the target machine to perform the import there. The migration wizard automatically creates all necessary scripts for all supported platforms and servers.
https://dev.mysql.com/doc/refman/8.4/en/added-deprecated-removed.html
Deprecated_use_i_s_processlist_count: Number of times Information Schema processlist table has been accessed. Deprecated_use_i_s_processlist_last_timestamp: Time of most recent access to Information Schema processlist table (timestamp). Options and ...
https://dev.mysql.com/doc/refman/8.4/en/view-algorithms.html
A reason to specify TEMPTABLE explicitly is that locks can be released on underlying tables after the temporary table has been created and before it is used to finish processing the statement. The optional ALGORITHM clause for CREATE VIEW or ALTER ...For MERGE, the text of a statement that refers to the view and the view definition are merged such that parts of the view definition replace corresponding parts of the ...