MySQL - Reference and Migration

Technical information on MySQL.

Language Elements

SQL language elements:

Single Line Comment # -- Until the end of line, -- must be followed by a space or tab

Identifiers

Names for database objects such as databases, tables, views, columns, indexes, triggers, procedures etc.

First character Alphanumeric
Subsequent characters Alphanumeric, _ (underscore) and $ (dollar)
Identifier quote character ` (backtick) " (double quotes) if ANSI_QUOTES mode is set (not set by default)

Maximum length:

Databases, tables, columns, indexes, views, procedures, triggers, constraints 64

MySQL Configuration

Database Schema and Data

SQL Language

How To - Most Popular Data Definition (DDL) Tasks

How To - Most Popular Queries and Expressions

Tables - DDL Options

Built-in Functions

Statements