Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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.7/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-supported-file-formats.html
To set the embedding model for all VECTOR columns in the table, load the data automatically and set the dialect parameter embed_model_id accordingly. You have the option to incrementally refresh external tables loaded with delta lake tables. Learn ... Review the various file formats supported for loading structured, semi-structured, and unstructured data in MySQL HeatWave from different ...
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 ...