What is the MySQL Size Limit for Database, Table, Column, Index name etc


Size limit for Databse Name,Table Name,Column Name, Index Name etc

 Type Name

 Maximum Length (characters)

 Database

 64 (includes NDB Cluster 8.0.18 and later)

 Table

 64 (includes NDB Cluster 8.0.18 and later)

 Column

 64

 Index

 64

 Constraint

 64

 Stored Program

 64

 View 

 64

 Tablespace

 64

 Server

 64

 Log File Group

 64

 Alias

 256 (some exception)

 Compound Statement Label

 16

 User-Defined Variable

 64

 Resource Group

 64


Related

find the nth highest salary in mysql without limit
How to find greater than average salary records in MySQL
how to find duplicate records in MySQL query
How to use second index forcefully in MySQL
How to get total number of rows in MySQL table with and without count