Search Results
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/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 ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-commands.html
This enables the character set to remain synchronized on the client and server if mysql is run with auto-reconnect enabled (which is not recommended), because the specified character set is used for reconnects. (See the description for the ... mysql ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-63.html
The migration wizard automatically creates all necessary scripts for all supported platforms and servers. SQL Editor Auto-Completion The SQL editor auto-completion improvements include the following changes: It now functions with all statement ...
https://dev.mysql.com/doc/connectors/en/connector-net-8-0-connection-options.html
AutoEnlist , Auto Enlist Default: true If AutoEnlist is set to true, which is the default, a connection opened using TransactionScope participates in this scope, it commits when the scope commits and rolls back if TransactionScope does not commit.