What is the maximum length of a table name, database name, and fieldname in MySQL?


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

    Please Login or Register to leave a response.

    Related 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...