MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 21 to 29 of 29 total results

« Previous
1
2
3
Next »

17.14 InnoDB Startup Options and System Variables

https://dev.mysql.com/doc/refman/9.7/en/innodb-parameters.html

innodb_autoinc_lock_mode Command-Line Format --innodb-autoinc-lock-mode=# System Variable innodb_autoinc_lock_mode Scope Global Dynamic No SET_VAR Hint Applies No Type Integer Default Value 2 Valid Values 012 The lock mode to use for generating ...

15.1.11 ALTER TABLE Statement

https://dev.mysql.com/doc/refman/9.7/en/alter-table.html

To reset the current auto-increment value: ALTER TABLE t1 AUTO_INCREMENT = 13; You cannot reset the counter to a value less than or equal to the value that is currently in use. ALTER TABLE tbl_name [alter_option [, alter_option] ...] ...

17.1.2 Best Practices for InnoDB Tables

https://dev.mysql.com/doc/refman/9.7/en/innodb-best-practices.html

Specify a primary key for every table using the most frequently queried column or columns, or an auto-increment value if there is no obvious primary key. Use joins wherever data is pulled from multiple tables based on identical ID values from those ...

28.4.26 The INFORMATION_SCHEMA INNODB_TABLESTATS View

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 ...

20.10 Frequently Asked Questions

https://dev.mysql.com/doc/refman/9.7/en/group-replication-frequently-asked-questions.html

These settings avoid the selection of duplicate auto-increment values for writes on group members, which causes rollback of transactions. What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 servers. Attempting to ...

A.1 MySQL 9.7 FAQ: General

https://dev.mysql.com/doc/refman/9.7/en/faqs-general.html

With the auto_increment_increment and auto_increment_offset system variables, you can set each server to generate auto-increment values that don't conflict with other servers. Why did MySQL version numbering skip versions 6 and 7 and go straight to ...

15.2.2 DELETE Statement

https://dev.mysql.com/doc/refman/9.7/en/delete.html

Auto-Increment Columns If you delete the row containing the maximum value for an AUTO_INCREMENT column, the value is not reused for a MyISAM or InnoDB table. DELETE is a DML statement that removes rows from a table. A DELETE statement can start ...

15.1.25 CREATE TABLE Statement

https://dev.mysql.com/doc/refman/9.7/en/create-table.html

To set the first auto-increment value for engines that do not support the AUTO_INCREMENT table option, insert a “dummy” row with a value one less than the desired value after creating the table, and then delete the dummy row. | {FULLTEXT | ...

14.4.2 Comparison Functions and Operators

https://dev.mysql.com/doc/refman/9.7/en/comparison-operators.html

See Obtaining Auto-Increment Values, and the description for the FLAG_AUTO_IS_NULL option at Connector/ODBC Connection Parameters. Table 14.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less ...