Maximum length of a table name in MySQL

Mysql

Mysql Problem Overview

What is the maximum length of a table name in MySQL?

Mysql Solutions

Solution 1 - Mysql

64 characters according to this.

Solution 2 - Mysql

It's 64 characters. The documentation shows these limits:

Identifier    Maximum Length (characters)
Database      64
Table         64
Column        64
Index         64
Constraint    64
Stored Procedure or Function    64
Trigger       64
View          64
Alias         256 
Compound Statement Label    16

Solution 3 - Mysql

Names for databases, tables, columns, and indexes can be up to 64 characters long. Alias names can be up to 256 characters long.

Solution 4 - Mysql

Mysql Maximum length of characters for all identifier are 64 characters except Alias (256) and Compound Statement Lablel (16)
Check the whole list here enter image description here

Categories
Recommended Mysql Solutions

Previous Solution:

jQuery, simple polling example

JqueryPolling

Next Solution:

What is the difference between "Include Directories" and "Additional Include Directories"

C++Visual Studio-2010Visual StudioCompilation

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionsniperView Question on Stackoverflow
Solution 1 - Mysqljames_bondView Answer on Stackoverflow
Solution 2 - MysqlBohemianView Answer on Stackoverflow
Solution 3 - MysqlLogicbombView Answer on Stackoverflow
Solution 4 - MysqlBibhudatta SahooView Answer on Stackoverflow