Search Results
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/known-issues.html
SELECT statements that insert zero or NULL values into an AUTO_INCREMENT column. SELECT with no ORDER BY, the SELECT may return rows in a different order (which results in a row having different ranks, hence getting a different number in the ...
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. To obtain a description of a MyISAM table or statistics about it, use the commands shown here. The ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-example-data.html
Note The information in this section applies to NDB Cluster running on both Unix and Windows platforms. Working with database tables and data in NDB Cluster is not much different from doing so in standard MySQL. There are two key points to keep in ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-import.html
--ai-increment=# Command-Line Format --ai-increment=# Type Integer Default Value 1 Minimum Value 1 Maximum Value 4294967295 For a table with a hidden primary key, specify the autoincrement increment, like the auto_increment_increment system variable ... ndb_import imports CSV-formatted data, such as that produced by mysqldump --tab, directly into NDB using the NDB ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump.html
The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. It dumps one or more MySQL databases for backup or transfer to ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlslap.html
--auto-generate-sql-add-autoincrement Command-Line Format --auto-generate-sql-add-autoincrement Type Boolean Default Value FALSE Add an AUTO_INCREMENT column to automatically generated tables. mysqlslap is a diagnostic program designed to emulate ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-bulk-data-loading.html
For example: CREATE TABLE t1 ( FTS_DOC_ID BIGINT unsigned NOT NULL AUTO_INCREMENT, title varchar(255) NOT NULL DEFAULT '', text mediumtext NOT NULL, PRIMARY KEY (`FTS_DOC_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE UNIQUE INDEX ... These ...
https://dev.mysql.com/doc/refman/8.4/en/replace.html
REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ... | VALUES row_constructor_list } REPLACE [LOW_PRIORITY | DELAYED] ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-reference.html
The following two sections provide basic information about the MySQL command-line options and system variables applicable to replication and the binary log. Replication Options and Variables The command-line options and system variables in the ...