Database, table, index, column, and alias names are identifiers. : Introduction « Introduction « MySQL Tutorial






  1. MySQL Tutorial
  2. Introduction
  3. Introduction

The maximum length for each type of identifier.

IdentifierMaximum Length (bytes)
Database64
Table64
Column64
Index64
Alias255


1.1.Introduction
1.1.1.Connecting To Your Database
1.1.2.To test whether a connection can even be made, execute the command STATUS.
1.1.3.Keywords may be entered in any lettercase.
1.1.4.You can use mysql as a simple calculator:
1.1.5.Database, table, index, column, and alias names are identifiers.