PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/innodb-recovery.html
For more information about how InnoDB handles auto-increment values, see Section 17.6.1.6, “AUTO_INCREMENT Handling in InnoDB”, and InnoDB AUTO_INCREMENT Counter Initialization. To achieve point-in-time recovery after restoring a backup, you can ...
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/jdv-examples.html
If the child join condition column for a singleton child has the AUTO_INCREMENT attribute, the JSON document being inserted can omit the join condition fields. If the parent join condition column for a nested child has the AUTO_INCREMENT attribute, ... To demonstrate the different DML operations you can execute on JSON duality views, create the customers and orders relational ...
https://dev.mysql.com/doc/refman/9.7/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/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. To obtain a description of a MyISAM table or statistics about it, use the commands shown here. The ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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 ...