Search Results
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-auto-increment-values.html
AUTO_INCREMENT columns can be used in MySQL for generating primary key or id values, but are not limited to these uses. getAutoIncrementValue() returns the AUTO_INCREMENT column value generated for the first inserted row only, so in this example, ...X DevAPI provides the getAutoIncrementValue() method to return the first AUTO_INCREMENT column value that was successfully inserted by the operation, taken from the return value of ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-auto-increment-values.html
AUTO_INCREMENT columns can be used in MySQL for generating primary key or id values, but are not limited to these uses. getAutoIncrementValue() returns the AUTO_INCREMENT column value generated for the first inserted row only, so in this example, ...X DevAPI provides the getAutoIncrementValue() method to return the first AUTO_INCREMENT column value that was successfully inserted by the operation, taken from the return value of ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-auto-increment-values.html
AUTO_INCREMENT columns can be used in MySQL for generating primary key or id values, but are not limited to these uses. getAutoIncrementValue() returns the AUTO_INCREMENT column value generated for the first inserted row only, so in this example, ...X DevAPI provides the getAutoIncrementValue() method to return the first AUTO_INCREMENT column value that was successfully inserted by the operation, taken from the return value of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-load.html
Lakehouse Auto Parallel Load infers the column names for Avro and Parquet files, and also for CSV files if has_header is true. For these situations, use the column names with the exclude_list option. If the table already exists, but has no data, use ... Note Do not use the external_tables option as of MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/monitor-alter-table-performance-schema.html
stage/innodb/alter table (log apply index): This stage includes the application of DML log generated while ALTER TABLE was running. stage/innodb/alter table (log apply table): This stage includes the application of concurrent DML log generated while ... You can monitor ALTER TABLE progress for InnoDB tables using Performance ...
https://dev.mysql.com/doc/refman/8.4/en/semijoins-antijoins.html
Assuming that class_num is a primary key in the class table, duplicate suppression is possible by using SELECT DISTINCT, but it is inefficient to generate all matching rows first only to eliminate duplicates later. WHERE ...); Here, ot_i and it_i ...
https://dev.mysql.com/doc/refman/8.4/en/time-zone-support.html
This includes the values displayed by functions such as NOW() or CURTIME(), and values stored in and retrieved from TIMESTAMP columns. Values for TIMESTAMP columns are converted from the session time zone to UTC for storage, and from UTC to the ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-cmd-query-iter.html
The following example shows how to iterate through the results after sending multiple statements: statement = 'SELECT 1; INSERT INTO t1 VALUES (); SELECT 2' for result in cnx.cmd_query_iter(statement): if 'columns' in result: columns = ... Syntax: ...Use cmd_query_iter() when sending multiple statements, and separate the statements with ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-cmd-query-iter.html
The following example shows how to iterate through the results after sending multiple statements: statement = 'SELECT 1; INSERT INTO t1 VALUES (); SELECT 2' for result in cnx.cmd_query_iter(statement): if 'columns' in result: columns = ... Syntax: ...Use cmd_query_iter() when sending multiple statements, and separate the statements with ...
https://dev.mysql.com/doc/internals/en/event-meanings.html
INTVAR_EVENT Written every time a statement uses an AUTO_INCREMENT column or the LAST_INSERT_ID() function; precedes other events for the statement. An INTVAR_EVENT is written with a "subtype" in the event data part: INSERT_ID_EVENT indicates the ...