This section takes you through some example syntax for creating and altering databases in MySQL. For more details on this syntax, visit Chapter 8, Modifying Data and Table Structures. These chapters will also outline the differences in syntax for Oracle, PostgreSQL, and SQL Server.
SQL for designing databases
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...
