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/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. row *************************** id: 1 select_type: SIMPLE table: x partitions: p0,p1 type: ALL possible_keys: NULL key: NULL key_len: NULL ...
https://dev.mysql.com/doc/refman/8.4/en/flow-control-functions.html
If no comparison or condition is true, the result after ELSE is returned, or NULL if there is no ELSE part. The CASE statement cannot have an ELSE NULL clause, and it is terminated with END CASE instead of END. If only one of expr2 or expr3 is ...
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/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/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/ndbapi/en/ndb-ndbindexscanoperation.html
Members Member names, types, and descriptions are shown in the following table: Table 2.47 IndexBound structure member names, types, and descriptions Name Type Description low_key const char* Row containing lower bound for scan (or NULL for scan ...
https://dev.mysql.com/doc/refman/8.4/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.4/en/invisible-columns.html
Invisible columns support the usual column attributes: NULL, NOT NULL, AUTO_INCREMENT, and so forth. row *************************** Table: t2 Create Table: CREATE TABLE `t2` ( `col1` int DEFAULT NULL, `col2` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT ...An invisible column is normally hidden to queries, but can be accessed if explicitly ...
https://dev.mysql.com/doc/refman/8.4/en/selecting-all.html
For example, you may happen to think that the birth date for Bowser doesn't seem quite right. Consulting your original pedigree papers, you find that the correct birth year should be 1989, not 1979. Fix only the erroneous record with an UPDATE ...