- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- MS Excel
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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:
Sr. No. | Identifier | Maximum Length (characters) |
---|---|---|
1 | Database | 64 |
2 | Table | 64 |
3 | Column | 64 |
4 | Index | 64 |
5 | Constraint | 64 |
6 | Stored Procedure or Function | 64 |
7 | Trigger | 64 |
8 | View | 64 |
9 | Event | 64 |
10 | Tablespace | 64 |
11 | Log File Group | 64 |
12 | Alias | 256 |
13 | Compound Statement Label | 16 |
Advertisements