Search Results
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-functionality-last-insert-id.html
Obtaining the value of column that uses AUTO_INCREMENT after an INSERT statement can be achieved in a number of different ways. For example, using Connector/ODBC you would execute two separate statements, the INSERT statement and the SELECT query ...In this case, try the following statement as an alternative: SELECT * FROM tbl WHERE auto IS NULL; This alternative method requires that sql_auto_is_null variable is not set to ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-auto-increment.html
Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is carried out subject to the following exceptions: A statement invoking a trigger or function that causes an update to an AUTO_INCREMENT column is not replicated ...This occurs because the order in which the rows are numbered depends on the specific storage engine used for the table and the order in which the rows were ...
https://dev.mysql.com/doc/refman/8.4/en/example-auto-increment.html
For example: INSERT INTO animals (id,name) VALUES(NULL,'squirrel'); When you insert any other value into an AUTO_INCREMENT column, the column is set to that value and the sequence is reset so that the next automatically generated value follows ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-auto-increment-columns.html
This view indicates which tables have AUTO_INCREMENT columns and provides information about those columns, such as the current and maximum column values and the usage ratio (ratio of used to possible values). The schema_auto_increment_columns view ...By default, rows are sorted by descending usage ratio and maximum column ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-load-event-based.html
Event-based incremental load automates the process of updating external tables based on changes to objects in Object Storage buckets. When setting up event-based incremental load, you specify the stream OCID in each external table by using the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-encoding.html
Auto Encoding generates string column encoding recommendations by analyzing column data, MySQL HeatWave query history, query performance data, and available memory on the MySQL node. This topic contains the following sections: Run Auto Encoding ...
https://dev.mysql.com/doc/refman/8.4/en/glossary.html
auto-increment A property of a table column (specified by the AUTO_INCREMENT keyword) that automatically adds an ascending sequence of values in the column. The values from such a column can be used as lookup keys in various contexts, and because ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-parallel-load-overview.html
Lakehouse Auto Parallel Load also includes Lakehouse Incremental Load, which can refresh tables after an initial load. Lakehouse Auto Parallel Load, which extends the Auto Parallel Load feature of MySQL HeatWave, facilitates the process of loading ...Defining LAKEHOUSE as the engine for tables that MySQL HeatWave ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-query-time-estimation.html
Auto Query Time Estimation provides: Runtimes for successfully executed queries Runtime estimates for EXPLAIN queries. This topic contains the following sections: Run Auto Query Time Estimation Auto Query Time Estimation Data Auto Query Time ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-parallel-load.html
You can load data into a MySQL HeatWave Cluster by using the Auto Parallel Load feature. Auto Parallel Load, which can be run manually from any MySQL client or connector, is implemented as a stored procedure named heatwave_load, which resides in ...