Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-processlist.html
row *************************** Id: 1 User: system user Host: db: NULL Command: Connect Time: 1030455 State: Waiting for source to send event Info: NULL *************************** 2. row *************************** Id: 2 User: system user Host: db: ... SHOW [FULL] PROCESSLIST Important The INFORMATION SCHEMA implementation of SHOW PROCESSLIST is deprecated and subject to removal in a future MySQL ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-copy-mysql-configuration.html
For any variables of the string data type, an empty value field means an empty string, except for nullable variables such as innodb_ft_server_stopword_table , for which an empty value field is taken as MYSQL NULL (i.e., a null value). Copying a ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-create-mysql-configuration.html
For any variables of the string data type, an empty value field means an empty string, except for nullable variables such as innodb_ft_server_stopword_table , for which an empty value field is taken as MYSQL NULL (i.e., a null value). Creating a ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-store-result.html
mysql_store_result() returns NULL if the statement did not return a result set (for example, if it was an INSERT statement), or an error occurred and reading of the result set failed. (An empty result set differs from a null pointer as a return ...
https://dev.mysql.com/doc/refman/8.4/en/limit-optimization.html
row *************************** id: 1 select_type: SIMPLE table: t partitions: NULL type: range possible_keys: i key: i key_len: 8 ref: NULL rows: 14 filtered: 100.00 Extra: Using index condition; Using filesort See also Section 10.9.2, ... If you ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-list.html
Note In MySQL 8.4, it is possible to match against only a list of integers (and possibly NULL—see Section 26.2.7, “How MySQL Partitioning Handles NULL”) when partitioning by LIST. List partitioning in MySQL is similar to range partitioning in ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-importing-data-bulk-ingesting.html
Importing Data Using the Bulk Ingest Feature 7.2.2.2 Importing Data Using the Bulk Ingest Feature Connect to a DB System and bulk ingest data from an Amazon S3 bucket to a DB System in the same region. This task requires the following: A client ...
https://dev.mysql.com/doc/refman/8.4/en/case.html
The CASE statement cannot have an ELSE NULL clause, and it is terminated with END CASE instead of END. This syntax cannot be used to test for equality with NULL because NULL = NULL is false. CASE case_value WHEN when_value THEN statement_list [WHEN ...
https://dev.mysql.com/doc/refman/8.4/en/merge-storage-engine.html
The column of the underlying table and the MERGE table can be NULL. The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as one. “Identical” means that all tables have ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-load-event-based.html
mysql> SET @input_list = '[{ "db_name": "lakehouse_db", "tables": [{ "table_name": "table_1", "engine_attribute": { "dialect": {"format": "csv"}, "auto_refresh_event_source": "ocid1.stream.oc1.iad...", "file": [{"uri": ... As of MySQL 9.4.1, you can ...