The are five kinds of identifiers that need to be considered in MySQL: databases, tables, columns, indexes and aliases. Databases, as stated are the containers for the tables and other associated database components. Tables hold the data that is used to produce information. Columns are the individual entities of the tables that contain the smallest portion of the data. Indexes in databases refer to the data structures that improve the speed of operations in a table. Aliases are temporary names assigned to database components. The identifiers that can be assigned to each component have their limitations: • Size - The following table describes the max length each database identifier can be assigned: Identifier Maximum Length Database 64 Bytes Table 64 Bytes Column ...
“The best way to be ready for the future is to invent it.”— John Sculley