create.sql

来自「J2EE 项目各个技术的源码」· SQL 代码 · 共 9 行

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');