What is the maximum length of each type of identifier in MySQL?

As we know that certain objects within MySQL are known as identifiers. These objects include a database, table, index, column, alias, view, stored procedure, partition, tablespace etc. Identifiers are stored using Unicode (UTF-8). The maximum length of each type of identifier is given in the following table:

Smita Kapse

Published on 20-Feb-2018 07:12:22

• Related Questions & Answers
• What is the maximum length of MySQL VARCHAR column?
• What is the maximum length of a table name in MySQL?
• What is the maximum length of string in Python?
• What is the maximum length of data we can put in a BLOB column in MySQL?
• What is the maximum length of data we can put in a TEXT column in MySQL?
• What is the default type of a hexadecimal value in MySQL?
• What is the Maximum Value of smallint(6) unsigned in MySQL?
• Maximum Length Chain of Pairs
• Maximum length of subarray such that sum of the subarray is even in C++
• What is an identifier in C language?
• What is the type of elements of the jagged array in C#?
• What is the max length of a Python string?
• What is the Length property of BitArray class in C#?
• What is a Virtual Circuit Identifier (VCID)?
• What is the maximum value of float in Python?