MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 71 to 76 of 76 total results

« Previous
6
7
8
Next »

28.4.9 The INFORMATION_SCHEMA INNODB_COLUMNS Table

https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-columns-table.html

LEN The column length, for example 4 for INT and 8 for BIGINT. For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_COLUMNS table has these columns: TABLE_ID An identifier ...

14.15 Information Functions

https://dev.mysql.com/doc/refman/8.0/en/information-functions.html

LAST_INSERT_ID(), LAST_INSERT_ID(expr) With no argument, LAST_INSERT_ID() returns a BIGINT UNSIGNED (64-bit) value representing the first automatically generated value successfully inserted for an AUTO_INCREMENT column as a result of the most ...It ...

20.5.6 Using MySQL Enterprise Backup with Group Replication

https://dev.mysql.com/doc/refman/8.0/en/group-replication-enterprise-backup.html

MySQL Enterprise Backup is a commercially-licensed backup utility for MySQL Server, available with MySQL Enterprise Edition. This section explains how to back up and subsequently restore a Group Replication member using MySQL Enterprise Backup. The ...

13.9 Using Data Types from Other Database Engines

https://dev.mysql.com/doc/refman/8.0/en/other-vendor-data-types.html

To facilitate the use of code written for SQL implementations from other vendors, MySQL maps data types as shown in the following table. These mappings make it easier to import table definitions from other database systems into MySQL. If you create ...

MySQL Glossary

https://dev.mysql.com/doc/refman/8.0/en/glossary.html

The column itself must be of BIGINT UNSIGNED NOT NULL type, with a unique index named FTS_DOC_ID_INDEX. These terms are commonly used in information about the MySQL database server. Files with this extension are always included in backups produced ...

5.6.9 Using AUTO_INCREMENT

https://dev.mysql.com/doc/refman/8.0/en/example-auto-increment.html

See Section 13.1.2, “Integer Types (Exact Value) - INTEGER, INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT” for the ranges of all the integer types. You can also explicitly assign 0 to the column to generate sequence numbers, unless the ...