Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-syntax.html
Like other MySQL storage engines, the NDB storage engine can handle a maximum of one AUTO_INCREMENT column per table, and this column must be indexed. However, in the case of an NDB table with no explicit primary key, an AUTO_INCREMENT column is ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-source.html
Attempting to set the value of auto_increment_increment or auto_increment_offset to a noninteger value produces an error, and the actual value of the variable remains unchanged. When Group Replication is started on a server, the value of ... This ...
https://dev.mysql.com/doc/refman/8.4/en/numeric-type-attributes.html
When you insert a value of NULL into an indexed AUTO_INCREMENT column, the column is set to the next sequence value. (AUTO_INCREMENT sequences begin with 1.) Storing 0 into an AUTO_INCREMENT column has the same effect as storing NULL, unless the ...
https://dev.mysql.com/doc/c-api/8.4/en/getting-unique-id.html
If you insert a record into a table that contains an AUTO_INCREMENT column, you can obtain the value stored into that column by calling the mysql_insert_id() function. You can check from your C applications whether a value was stored in an ...When ...
https://dev.mysql.com/doc/internals/en/mismatch-of-focus-of-test-and-code-sequence.html
CREATE TABLE t1 ( id INT NOT NULL AUTO_INCREMENT, my_column VARCHAR(30), name LONGTEXT, PRIMARY KEY (id)); INSERT INTO t1(my_column,name) VALUES('2','two'); INSERT INTO t1(my_column,name) VALUES('1','one'); INSERT INTO t1(my_column,name) ...
https://dev.mysql.com/doc/refman/8.4/en/insert.html
Because AUTO_INCREMENT values are generated after other value assignments, any reference to an AUTO_INCREMENT column in the assignment returns a 0. For INSERT examples involving AUTO_INCREMENT column values, see Section 5.6.9, “Using ... INSERT ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-desc.html
--auto-inc, -a Show the next value for a table's AUTO_INCREMENT column, if it has one. ndb_desc provides a detailed description of one or more NDB tables. Usage ndb_desc -c connection_string tbl_name -d db_name [options] ndb_desc -c ...
https://dev.mysql.com/doc/x-devapi-userguide/en/dynamic-sql.html
A quoting function exists to escape SQL names and identifiers. Session.quoteName() escapes the identifier given in accordance to the settings of the current connection. Note The quoting function must not be used to escape values. Use the value ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-auto-increment-values.html
AUTO_INCREMENT columns can be used in MySQL for generating primary key or id values, but are not limited to these uses. This section explains how to retrieve AUTO_INCREMENT values when adding rows using X DevAPI. X DevAPI provides the ...The reason ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/schema-advisor-ref.html
MySQL's mechanism for doing this is the AUTO_INCREMENT column attribute, which enables you to generate sequential numbers automatically. If you try to generate a number that exceeds the maximum allowed by the underlying data type, such as by ...