What is the maximum length of a table name, database name, and fieldname in MySQL?
devquora
Posted On: Feb 22, 2018
The following table describes the maximum length for each type of identifier.
- Database 64 bytes
- Table 64 bytes
- Column 64 bytes
- Index 64 bytes
- Alias 255 bytes
There are some restrictions on the characters that may appear in identifiers.
Related Questions
Subscribe Our NewsLetter
Never Miss an Articles from us.
Recent Articles
Featured Categories
- Common Interview Questions
- Python Flask Interview Questions
- NoSQL Interview Questions
- jQuery Interview Questions
- C Programming Interview Questions
- AngularJs Interview Questions
- Node JS Interview Questions
- JavaScript Interview Questions
- Core Java Interview Questions
- HTML Interview Questions
- Laravel Interview Questions
- Wordpress Interview Questions
- PHP Interview Questions
Mysql Interview Questions
What is MySql ?
MySql is a multi-threading, multi-user open source SQL database management system . It is typically used for web applica..
Mysql Interview Questions
In which language MYSQL it is written ?
MySql is written in C and C++ programming and SQL parser written in yacc...