insert into employee values

(NULL, Laura Thomson, Programmer, 128);

insert into employee values

set employeeid=null, name='laura Thomson'

job='programmer', departmentid=128;

insert into employee values

(NULL, 'Laura Thomson', 'Programmer', 128);

insert into employee values

(NULL, 'Laura O'leary*, 'Programmer', 128);

INSERT ( 'Olsen') INTO Persons (LastName);

INSERT INTO Persons (LastName) VALUES ( 'Olsen');

INSERT INTO Persons ( 'Olsen') INTO LastName;

DELETE TABLE <table_name>

DROP TABLE <table_name> FROM DATABASE

DELETE TABLE <table_name> FROM DATABASE

DROP TABLE <table_name>

CREATE DATABASE

SHOW DATABASE

DROP DATABASE

USE DATABASE

id SERIAL

id INT AUTO_INCREMENT PRIMARY KEY

id INT DEFAULT MAX (id) +1

id INT IDENTITY