Search Results
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/gis-general-property-functions.html
Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL, the return value is NULL. The functions listed in this section do not restrict their argument and accept a geometry value of ...
https://dev.mysql.com/doc/refman/8.4/en/multifactor-authentication.html
Authentication involves one party establishing its identity to the satisfaction of a second party. Multifactor authentication (MFA) is the use of multiple authentication values (or “factors”) during the authentication process. MFA provides ...
https://dev.mysql.com/doc/refman/8.4/en/replication-administration-skip.html
If replication stops due to an issue with an event in a replicated transaction, you can resume replication by skipping the failed transaction on the replica. Before skipping a transaction, ensure that the replication I/O (receiver) thread is ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-bind-named-param.html
In the absence of named parameters, pass in NULL as the array of bind parameter names. It succeeds without any effect (in corner cases) if the bind argument count parameter is zero or if the bind array pointer is NULL. The unnamed parameter has NULL ... bool mysql_stmt_bind_named_param(MYSQL_STMT *stmt, MYSQL_BIND *binds, unsigned n_params, const char **names) Description mysql_stmt_bind_named_param() sets up unnamed and named (query attributes) bind parameters for prepared ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-7.html
(Bug #25207784) X DevAPI: It is no longer permitted to pass an empty search condition, such as the NULL value or an empty string, to the Collection.Modify() and Collection.Remove() methods. (WL #10553) Bugs Fixed X DevAPI: createView() failed with a ... MySQL Connectors and other MySQL client tools and applications now synchronize the first digit of their version number with the (latest) MySQL server version they ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-prepare-an-anomaly-detection-model.html
The data has a column, target, that has three possible values: 0 for normal, 1 for anomalous, and NULL for unlabeled. This topic describes how to prepare the data to use for two anomaly detection machine learning models: a semi-supervised anomaly ...
https://dev.mysql.com/doc/refman/8.4/en/join.html
If there is no matching row for the right table in the ON or USING part in a LEFT JOIN, a row with all columns set to NULL is used for the right table. SELECT left_tbl.* FROM { OJ left_tbl LEFT OUTER JOIN right_tbl ON left_tbl.id = right_tbl.id } ...