Using DDL to Create Tables and Indexes

MySQL Tutorials - Herong's Tutorial Examples

∟Using DDL to Create Tables and Indexes

This chapter provides tutorial notes on DDL (Data Definition Language) statements. Topics include CREATE TABLE, CREATE INDEX, and ALTER TABLE statements; selecting column options when creating tables.

CREATE TABLE - Statement to Create Tables

Column Options When Creating Tables

CREATE INDEX - Statement to Create Indexes

ALTER TABLE - Statement to Alter Table Structures

Takeaways:

DLL (Data Definition Language) contains CREATE, ALTER and DROP statements.
CREATE TABLE statements are used to create tables.
CREATE INDEX statements are used to create indexes.
ALTER TABLE statements are used to alter table structures.

All notes and examples in chapter are tested with MySQL 8.0, 5.7, 5.6, 5.0 and 4.0 servers.

Table of Contents

About This Book

Introduction of SQL

MySQL Introduction and Installation

Introduction of MySQL Programs

PHP Programs and MySQL Server

Perl Programs and MySQL Servers

Java Programs and MySQL Servers

Datatypes and Data Literals

Operations and Expressions

Character Strings and Bit Strings

Commonly Used Functions

Table Column Types for Different Types of Values

►Using DDL to Create Tables and Indexes

Using DML to Insert, Update and Delete Records

Using SELECT to Query Database

Window Functions for Statistical Analysis

Use Index for Better Performance

Transaction Management and Isolation Levels

Locks Used in MySQL

Defining and Calling Stored Procedures

Variables, Loops and Cursors Used in Stored Procedures

System, User-Defined and Stored Procedure Variables

MySQL Server Administration

Storage Engines in MySQL Server

InnoDB Storage Engine - Primary and Secondary Indexes

Performance Tuning and Optimization

Bulk Changes on Large Tables

MySQL Server on macOS

Installing MySQL Server on Linux

Connection, Performance and Second Instance on Linux

Archived Tutorials

Full Version in PDF/EPUB