Search Results
https://dev.mysql.com/doc/mysql-shell/9.4/en/setting-up-innodb-cluster-and-mysql-router.html
In the following example, we complete the following tasks using a sandbox deployment with AdminAPI to deploy an InnoDB Cluster with MySQL Router. Deploying and using local sandbox instances of MySQL allows you to test out the functionality locally, ...
https://dev.mysql.com/doc/refman/8.4/en/flow-control-functions.html
mysql> SELECT IFNULL(1,0); -> 1 mysql> SELECT IFNULL(NULL,10); -> 10 mysql> SELECT IFNULL(1/0,10); -> 10 mysql> SELECT IFNULL(1/0,'yes'); -> 'yes' The default return type of IFNULL(expr1,expr2) is the more “general” of the two expressions, in ...
https://dev.mysql.com/doc/refman/8.4/en/engine-condition-pushdown-optimization.html
column IS [NOT] NULL column IN (value_list) Each item in the value_list must be a constant, literal value. A string value to be compared with a column must use the same collation as the column. row *************************** id: 1 select_type: ...
https://dev.mysql.com/doc/refman/8.4/en/show-index.html
row *************************** Table: city Non_unique: 0 Key_name: PRIMARY Seq_in_index: 1 Column_name: ID Collation: A Cardinality: 4188 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: Index_comment: Visible: YES Expression: NULL ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-model-import.html
The table to import should have the following columns, and their recommended parameters: chunk_id: INT AUTO_INCREMENT PRIMARY KEY model_object: LONGTEXT NOT NULL model_metadata: JSON DEFAULT NULL See Model Metadata. Use the ML_MODEL_IMPORT routine ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-last-insert-id.html
getGeneratedKeys() is the preferred method to use if you need to retrieve AUTO_INCREMENT keys and through JDBC; this is illustrated in the first example below. The second example shows how you can retrieve the same value using a standard SELECT ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-last-insert-id.html
getGeneratedKeys() is the preferred method to use if you need to retrieve AUTO_INCREMENT keys and through JDBC; this is illustrated in the first example below. The second example shows how you can retrieve the same value using a standard SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-row-format.html
An SQL NULL value reserves one or two bytes in the record directory. An SQL NULL value reserves zero bytes in the data part of the record if stored in a variable-length column. Reserving fixed space for NULL values permits columns to be updated in ... The row format of a table determines how its rows are physically stored, which in turn can affect the performance of queries and DML ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-using-an-anomaly-detection-model.html
If the default NULL value is used for summary_threshold, then only rows labeled as anomalies are summarized. For the option to set the user name, you can set it to NULL. mysql> CALL sys.ML_MODEL_LOAD('anomaly_detection_semi_supervised_use_case', ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-system-variables.html
group_replication_recovery_tls_ciphersuites Command-Line Format --group-replication-recovery-tls-ciphersuites=value System Variable group_replication_recovery_tls_ciphersuites Scope Global Dynamic Yes SET_VAR Hint Applies No Type String Default ...