Search Results
https://dev.mysql.com/doc/mysqld-version-reference/en/keywords-9-6.html
This section provides information about keywords and reserved words in MySQL 9.6. MySQL 9.6 Keywords and Reserved Words MySQL 9.6 New Keywords and Reserved Words MySQL 9.6 Removed Keywords and Reserved Words MySQL 9.6 Keywords and Reserved Words ...
https://dev.mysql.com/doc/mysqld-version-reference/en/keywords-9-7.html
This section provides information about keywords and reserved words in MySQL 9.7. MySQL 9.7 Keywords and Reserved Words MySQL 9.7 New Keywords and Reserved Words MySQL 9.7 Removed Keywords and Reserved Words MySQL 9.7 Keywords and Reserved Words ...
https://dev.mysql.com/doc/relnotes/connector-net/en/news-8-0-27.html
(Bug #33191344) Transactions started by the SHOW COLLATION statement on all MySQL 8.0 server versions were not closed when the autocommit system variable was set to zero. Functionality Added or Changed Bugs Fixed Functionality Added or Changed ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-create-temp-table.html
Unlike the MySQL temporary table that exists in DB System, MySQL HeatWave temporary tables are stored in the MySQL HeatWave Cluster by the MySQL HeatWave engine and are used for MySQL HeatWave processing. After a session has created a temporary ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-functions.html
For example: mysql> SET time_zone = timezone; For information about time zone offsets, see MySQL Server Time Zone Support. As of MySQL 9.2.2, the maximum output width of the following functions is 65,332 bytes: JSON_ARRAYAGG() JSON_OBJECTAGG() ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-terminology.html
When running MySQL NDB Cluster manually, configuration is accomplished using cluster configuration parameters, MySQL server options, and MySQL system and status variables; MySQL Cluster Manager masks the differences between these, providing a ...
https://dev.mysql.com/doc/refman/9.7/en/controlling-optimizer.html
MySQL provides optimizer control through system variables that affect how query plans are evaluated, switchable optimizations, optimizer and index hints, and the optimizer cost model. The server maintains histogram statistics about column values in ...Like other data dictionary tables, this table is not directly accessible by ...
https://dev.mysql.com/doc/refman/9.7/en/create-trigger.html
MySQL stores the sql_mode system variable setting in effect when a trigger is created, and always executes the trigger body with this setting in force, regardless of the current server SQL mode when the trigger begins executing. CREATE [DEFINER = ...
https://dev.mysql.com/doc/refman/9.7/en/data-dictionary-information-schema.html
The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. In particular, for each INFORMATION_SCHEMA table that is a view on data dictionary tables: The server no longer must create a ...
https://dev.mysql.com/doc/refman/9.7/en/data-masking-plugin-usage.html
Suppose that a file named de_cities.txt contains these city names in Germany: Berlin Munich Bremen Also suppose that a file named us_cities.txt contains these city names in the United States: Chicago Houston Phoenix El Paso Detroit Assume that the ...In that case, copy the dictionary files to that directory so that the MySQL server can access ... Before using MySQL Enterprise Data Masking, install it according to the ...