Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tablestats-table.html
This column is reset each time table statistics are recalculated AUTOINC The next number to be issued for any auto-increment-based operation. The rate at which the AUTOINC value changes depends on how many times auto-increment numbers have been ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-per-table-tablespaces.html
The innodb_autoextend_increment variable, which defines the increment size for extending the size of an auto-extending shared tablespace file when it becomes full, does not apply to file-per-table tablespace files, which are auto-extending ... A ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-index-types.html
If there is no logical unique and non-null column or set of columns to use a the primary key, add an auto-increment column. Auto-increment column values are unique and are added automatically as new rows are inserted. Each InnoDB table has a ...
https://dev.mysql.com/doc/refman/8.4/en/insert-on-duplicate.html
ON DUPLICATE KEY UPDATE inserts or updates a row, the LAST_INSERT_ID() function returns the AUTO_INCREMENT value. If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-table-info.html
Auto increment key, Last value The key number associated the table's AUTO_INCREMENT column, and the most recently generated value for this column. Most tables manage with 2 bytes, but this is calculated automatically by MySQL. To obtain a ...
https://dev.mysql.com/doc/refman/8.4/en/using-innodb-tables.html
You can declare an auto-increment column so that ascending values are filled in automatically as rows are inserted: # The value of ID can act like a pointer between related items in different tables. CREATE TABLE t5 (id INT AUTO_INCREMENT, b CHAR ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-model-catalog-table.html
The MODEL_CATALOG table (ML_SCHEMA_user_name.MODEL_CATALOG) has the following columns: model_id A primary key, and a unique auto-incrementing numeric identifier for the model. The model_object_catalog table has the following columns: chunk_id A ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-high-availability-and-clustering.html
Default Value random Since Version 5.0.6 loadBalanceAutoCommitStatementRegex When load-balancing is enabled for auto-commit statements (via 'loadBalanceAutoCommitStatementThreshold'), the statement counter will only increment when the SQL matches ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-manually-how-to.html
If you choose not to Load Structured Data Using Lakehouse Auto Parallel Load, you can load external data manually. As of MySQL 9.4.0, you can use the CREATE EXTERNAL TABLE statement, which automatically sets ENGINE to lakehouse, and ...CREATE TABLE ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-high-availability-and-clustering.html
Default Value random Since Version 5.0.6 loadBalanceAutoCommitStatementRegex When load-balancing is enabled for auto-commit statements (via 'loadBalanceAutoCommitStatementThreshold'), the statement counter will only increment when the SQL matches ...