SQL for designing databases

This section takes you through some example syntax for creating and altering databases in MySQL. For more details on this syntax, visit Chapter 4, Designing and Creating a Database, and Chapter 8, Modifying Data and Table Structures. These chapters will also outline the differences in syntax for Oracle, PostgreSQL, and SQL Server.

Syntax for creating a database

In order to create a database, you can use the following sample syntax:

CREATE DATABASE yourschema; 

Syntax for creating and altering tables

In order to create a table, you can use the...