Java EE 6 example source code file (create.sql)

This example Java EE 6 source code file (create.sql) is included in the DevDaily.com "Java Source Code Warehouse" project. The intent of this project is to help you "Learn Java by Example" ^TM.

Java - Java EE 6 tags/keywords

create, firstname, firstname, insert, into, lastname, not, not, null, null, table, values, varchar, varchar

The Java EE 6 create.sql source code

CREATE TABLE customer (
 customerid VARCHAR(8) NOT NULL,
 lastname VARCHAR(24) NOT NULL,
 firstname VARCHAR(24) NOT NULL,
 primary key (customerid)
);

INSERT INTO customer VALUES('SUN00001', 'LastName', 'FirstName');