MySQL Tutorials - Herong's Tutorial Examples - v4.40, by Dr. Herong Yang
Using DDL to Create Tables and Indexes
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
Takeaways:
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
MySQL Introduction and Installation
Introduction of MySQL Programs
Perl Programs and MySQL Servers
Java Programs and MySQL Servers
Character Strings and Bit Strings
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
Transaction Management and Isolation Levels
Defining and Calling Stored Procedures
Variables, Loops and Cursors Used in Stored Procedures
Using Administration Statements
Installing MySQL Server on Linux