Search Results
https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/news-8-4-1.html
It was removed due to a critical issue that could stop the server from restarting following the creation of a very large number of tables (8001 or more). In addition, the cleanup of old events has been improved, which improves the cleanup of failed ...ndbinfo Information Database: Added a type column to the transporter_details table in the ndbinfo information ... MySQL NDB Cluster 8.4.1 is a new LTS release of NDB 8.4, based on MySQL Server 8.4 and including features in ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/dynamic-sql.html
This is true for working with collections and for working with relational tables. A quoting function exists to escape SQL names and identifiers. Session.quoteName() escapes the identifier given in accordance to the settings of the current ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/dynamic-sql.html
This is true for working with collections and for working with relational tables. A quoting function exists to escape SQL names and identifiers. Session.quoteName() escapes the identifier given in accordance to the settings of the current ...
https://dev.mysql.com/doc/refman/8.4/en/view-syntax.html
The CREATE VIEW statement creates a new view (see Section 15.1.23, “CREATE VIEW Statement”). A view can be created from many kinds of SELECT statements. To alter the definition of a view or drop a view, use ALTER VIEW (see Section 15.1.11, ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-26.html
SELECT statements where the SELECT query is offloaded to MySQL HeatWave and the table is created on the MySQL Database Service instance. (WL #14328, WL #14510, WL #14431, WL #14328, WL #14651) Auto Parallel Load The new MySQL HeatWave Auto Parallel ... Advisor Auto Parallel Load Auto Scheduling Functionality Added or Changed Advisor The new MySQL HeatWave Advisor provides string column encoding and data placement key recommendations based on machine learning models, data analysis, and MySQL HeatWave query ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-plugin-usage.html
Creating Views that Display Masked Data If masked data from a table is used for multiple queries, it may be convenient to define a view that produces masked data. Suppose that a customer table containing customer records has these columns: id: ...
https://dev.mysql.com/doc/internals/en/myisam-column-attributes.html
If you run MySQL 5.0 with the --new option, MySQL will show old VARCHAR columns as 'CHAR' in SHOW CREATE TABLE. Some further random notes about the new format: In old tables (from MySQL 4.1 and earlier), VARCHAR columns have type ... Next I'll ...
https://dev.mysql.com/doc/refman/8.4/en/descending-indexes.html
For InnoDB full-text search, this means that the index required on the FTS_DOC_ID column of the indexed table cannot be defined as a descending index. MySQL supports descending indexes: DESC in an index definition is no longer ignored but causes ...
https://dev.mysql.com/doc/refman/8.4/en/other-vendor-data-types.html
If you create a table with types used by other vendors and then issue a DESCRIBE tbl_name statement, MySQL reports the table structure using the equivalent MySQL types. To facilitate the use of code written for SQL implementations from other ...
https://dev.mysql.com/doc/refman/8.4/en/symbolic-links.html
For InnoDB tables, use the DATA DIRECTORY clause of the CREATE TABLE statement instead of symbolic links, as explained in Section 17.6.1.2, “Creating Tables Externally”. You can move databases or tables from the database directory to other ...