Search Results
https://dev.mysql.com/doc/refman/8.4/en/data-masking-plugin-functions.html
Return value: The masked string, or NULL if either margin is negative. Return value: The masked string, or NULL if either margin is negative. Return value: A random integer in the range from lower to upper, inclusive, or NULL if the upper argument ... The MySQL Enterprise Data Masking and De-Identification plugin library includes several functions, which may be grouped into these categories: Data Masking Plugin Functions Random Data Generation Plugin Functions Random Data Dictionary-Based Plugin Functions These functions support the single-byte latin1 character set for string arguments and return ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-component-functions.html
Return value: The masked Canada SIN as a string encoded in the utf8mb4 character set, an error if the argument is not the correct length, or NULL if str is in incorrect format or contains a multibyte character. Return value: The masked International ...mask_canada_sin(str [, mask_char]) Masks a Canada Social Insurance Number (SIN) and returns the number with all meaningful digits replaced by 'X' ...
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
NOT NULL | NULL If neither NULL nor NOT NULL is specified, the column is treated as though NULL had been specified. In MySQL 8.4, only the InnoDB, MyISAM, and MEMORY storage engines support indexes on columns that can have NULL values. In other ...| ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-tpch-quickstart.html
row *************************** id: 1 select_type: SIMPLE table: lineitem partitions: NULL type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 56834662 filtered: 33.33 Extra: Using where; Using secondary engine RAPID If the query ... The tpch Analytics Quickstart shows how to import data into the DB System using the MySQL Shell Parallel Table Import Utility, manually loading data into MySQL HeatWave Cluster, and running ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-generate-table.html
The input column must not be a part of the primary key and must not have NULL values or empty strings. And, the image column must not have NULL values or empty strings. The ML_GENERATE_TABLE routine runs multiple text generation or summarization ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-auto-increment-handling.html
An example follows, where c1 is an AUTO_INCREMENT column of table t1: INSERT INTO t1 (c1,c2) VALUES (1,'a'), (NULL,'b'), (5,'c'), (NULL,'d'); Another type of “mixed-mode insert” is INSERT ... To make this clear, consider an example that uses ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-modifiers.html
These rows have the country and products columns set to NULL. This row has the year, country, and products columns set to NULL. The NULL indicators in each super-aggregate row are produced when the row is sent to the client. For any column in the ...
https://dev.mysql.com/doc/refman/8.4/en/switchable-optimizations.html
(Depending on the nullability of the derived table, this can sometimes be simplified further to an inner join.) This can be done for a subquery which meets the following conditions: The subquery does not make use of any nondeterministic functions, ...Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-debugging-queries.html
row *************************** id: 1 select_type: SIMPLE table: flightschedule partitions: NULL type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 9828 filtered: 100 Extra: NULL 1 row in set, 1 warning (0.2389 sec) Execute the ...
https://dev.mysql.com/doc/refman/8.4/en/myisampack.html
When the table is used later, the server reads into memory the information needed to decompress columns. This results in much better performance when accessing individual rows, because you only have to uncompress exactly one row. MySQL uses mmap() ...