What is the maximum length of each type of identifier in MySQL?

As we all know, some objects in MySQL are called identifiers. These objects include databases, tables, indexes, columns, aliases, views, stored procedures, partitions, table spaces, etc. Identifiers are stored using Unicode (UTF-8). The maximum length of each type of identifier is as shown in the following table:

##1Database 64##23##4Index 5 Constraints Stored procedure or functionTriggerView64##10 64116412256 Compound statement tag##16

Sr. Number	Identifier	Maximum length (characters)
2	Form	64
Column	64
	64
	64	##6
	64	7
	64	# #8
		##9 Event
64		Tablespace
		Log file group
		Alias
	13

The above is the detailed content of What is the maximum length of each type of identifier in MySQL?. For more information, please follow other related articles on the PHP Chinese website!