Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-table-generated-columns.html
The AUTO_INCREMENT attribute cannot be used in a generated column definition. An AUTO_INCREMENT column cannot be used as a base column in a generated column definition. Values of a generated column are computed from an expression included in the ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-select.html
For example: mysql> CREATE TABLE test (a INT NOT NULL AUTO_INCREMENT, -> PRIMARY KEY (a), KEY(b)) -> ENGINE=InnoDB SELECT b,c FROM test2; This creates an InnoDB table with three columns, a, b, and c. For example, the AUTO_INCREMENT attribute is not ... You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates new columns for all elements in the ...
https://dev.mysql.com/doc/refman/8.4/en/creating-spatial-indexes.html
The table also has an AUTO_INCREMENT column fid for storing object ID values. For InnoDB and MyISAM tables, MySQL can create spatial indexes using syntax similar to that for creating regular indexes, but using the SPATIAL keyword. For storage ...
https://dev.mysql.com/doc/refman/8.4/en/extensions-to-ansi.html
For example: mysql> SELECT col1=1 AND col2=2 FROM my_table; The LAST_INSERT_ID() function returns the most recent AUTO_INCREMENT value. MySQL Server supports some extensions that you are not likely to find in other SQL DBMSs. Be warned that if you ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search-mecab.html
The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation when working with ideographic languages that do not use word delimiters. To address this limitation ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search-ngram.html
The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation when working with ideographic languages that do not use word delimiters. To address this limitation, ...
https://dev.mysql.com/doc/refman/8.4/en/getting-information.html
Extra displays special information about columns: If a column was created with the AUTO_INCREMENT option, the value is auto_increment rather than empty. What if you forget the name of a database or table, or what the structure of a given table is ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-columns-table.html
The value is nonempty in these cases: auto_increment for columns that have the AUTO_INCREMENT attribute. The related ST_GEOMETRY_COLUMNS table provides information about table columns that store spatial data. The COLUMNS table has these columns: ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking.html
AUTO-INC Locks An AUTO-INC lock is a special table-level lock taken by transactions inserting into tables with AUTO_INCREMENT columns. Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC ...
https://dev.mysql.com/doc/refman/8.4/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 ...