CREATE

CREATE is used to create databases or to add tables to a database.

To create a new database:

CREATE DATABASE foo;

To add a table to an existing database:

CREATE TABLE books (   isbn   varchar(20)  default NULL,   title  varchar(255) default NULL,   author varchar(255) default NULL );