Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/partitioning-limitations.html
This section discusses current restrictions and limitations on MySQL partitioning support. The following constructs are not permitted in partitioning expressions: Stored procedures, stored functions, UDFs, or plugins. For a list of SQL functions ...
https://dev.mysql.com/innodb-restrictions.html
An AUTO_INCREMENT column ai_col must be defined as part of an index such that it is possible to perform the equivalent of an indexed SELECT MAX(ai_col) lookup on the table to obtain the maximum column value. InnoDB sets an exclusive lock on the end ... Limits on InnoDB tables are described under the following topics in this section: Maximums and Minimums Restrictions on InnoDB Tables Locking and Transactions Warning Before using NFS with InnoDB, review potential issues outlined in Using NFS with ...
https://dev.mysql.com/create-index.html
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... This guideline is especially important for InnoDB tables, where the primary key determines the ...
https://dev.mysql.com/sys-schema-auto-increment-columns.html
This view indicates which tables have AUTO_INCREMENT columns and provides information about those columns, such as the current and maximum column values and the usage ratio (ratio of used to possible values). The schema_auto_increment_columns view ...By default, rows are sorted by descending usage ratio and maximum column ...
https://dev.mysql.com/server-system-variables.html
insert_id The value to be used by the following INSERT or ALTER TABLE statement when inserting an AUTO_INCREMENT value. If no AUTO_INCREMENT value was successfully inserted, the SELECT statement returns no row. The behavior of retrieving an ... The ...
https://dev.mysql.com/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. There are some exceptions to this behavior for InnoDB tables, as discussed in Section ...
https://dev.mysql.com/mysql-cluster-online-operations.html
row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) NOT NULL AUTO_INCREMENT, `c2` int(11) DEFAULT NULL, `c3` int(11) DEFAULT NULL, PRIMARY KEY (`c1`) ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 1 row in set (0.00 ... MySQL NDB Cluster 8.0 supports online table schema changes using the standard ALTER TABLE syntax employed by the MySQL Server (ALGORITHM=DEFAULT|INPLACE|COPY), and described ...
https://dev.mysql.com/archive-storage-engine.html
The AUTO_INCREMENT column can have either a unique or nonunique index. The ARCHIVE engine also supports the AUTO_INCREMENT table option in CREATE TABLE statements to specify the initial sequence value for a new table or reset the sequence value for ... The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small ...
https://dev.mysql.com/mysql-stmt-insert-id.html
uint64_t mysql_stmt_insert_id(MYSQL_STMT *stmt) Returns the value generated for an AUTO_INCREMENT column by the prepared INSERT or UPDATE statement. Use this function after you have executed a prepared INSERT statement on a table which contains an ...
https://dev.mysql.com/example-foreign-keys.html
In MySQL, InnoDB tables support checking of foreign key constraints. See Chapter 15, The InnoDB Storage Engine, and Section 1.8.2.3, “Foreign Key Differences”. A foreign key constraint is not required merely to join two tables. It is extremely ...
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-fct-auto_increment-p-3.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.
