https://dev.mysql.com/atomic-ddl.html
An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic transaction. The transaction is either committed, with applicable changes persisted ...
https://dev.mysql.com/c-api-function-overview.html
mysql_insert_id(): Returns the ID generated for an AUTO_INCREMENT column by the previous query. The following list summarizes the functions available in the C API. For greater detail, see the descriptions in Section 28.7.7, “C API Function ...
https://dev.mysql.com/c-api-prepared-statement-function-overview.html
mysql_stmt_insert_id(): Returns the ID generated for an AUTO_INCREMENT column by a prepared statement. The following list summarizes the functions available for prepared statement processing. For greater detail, see the descriptions in Section ...
https://dev.mysql.com/converting-tables-to-innodb.html
If the table already has a primary key on some longer column, such as a VARCHAR, consider adding a new unsigned AUTO_INCREMENT column and switching the primary key to that, even if that column is not referenced in queries. If you have MyISAM tables ...
https://dev.mysql.com/create-table-check-constraints.html
Nongenerated and generated columns are permitted, except columns with the AUTO_INCREMENT attribute and columns in other tables. Prior to MySQL 8.0.16, CREATE TABLE permits only the following limited version of table CHECK constraint syntax, which ...
https://dev.mysql.com/create-table-ndb-table-comment-options.html
In MySQL NDB Cluster, the table comment in a CREATE TABLE or ALTER TABLE statement can also be used to specify an NDB_TABLE option, which consists of one or more name-value pairs, separated by commas if need be, following the string NDB_TABLE=.
https://dev.mysql.com/create-table-secondary-indexes.html
A secondary index defined on a virtual column is sometimes referred to as a “virtual index”. A secondary index may be created on one or more virtual columns or on a combination of virtual columns and regular columns or stored generated columns.
https://dev.mysql.com/create-tablespace.html
The precise syntax and semantics depend on the storage engine used. MySQL NDB Cluster also supports tablespaces using the NDB storage engine. Considerations for InnoDB Considerations for NDB Cluster Options Notes InnoDB Examples NDB Example ...
https://dev.mysql.com/explain.html
In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query execution plan (that is, an explanation of how MySQL would execute a query). The following discussion uses ...
https://dev.mysql.com/faqs-general.html
However, MySQL has an AUTO_INCREMENT system, which in MySQL 8.0 can also handle inserts in a multi-master replication setup. With the auto_increment_increment and auto_increment_offset system variables, you can set each server to generate ...Why did ...
