postalcodes.sql

来自「此程序都是企业级 的数据库开发程序 全面揭示了JAVA对数据库的操作」· SQL 代码 · 共 22 行

DROP TABLE POSTALCODES;

CREATE TABLE POSTALCODES
   (
      POSTALCODE VARCHAR(12) NOT NULL,
      CITY VARCHAR(30) NOT NULL,
      STATEPROV VARCHAR(30) NOT NULL,
      COUNTRYID NUMBER(10) NOT NULL 
   );

INSERT INTO POSTALCODES VALUES('06484','Shelton','CT',1);
INSERT INTO POSTALCODES VALUES('06488','Southbury','CT',1);
INSERT INTO POSTALCODES VALUES('06877','West Haven','CT',1);
INSERT INTO POSTALCODES VALUES('06628','Trumbull','CT',1);
INSERT INTO POSTALCODES VALUES('10022','Manhattan','NY',1);
INSERT INTO POSTALCODES VALUES('06601','Bridgeport','CT',1);
INSERT INTO POSTALCODES VALUES('92121','San Diego','CA',1);
INSERT INTO POSTALCODES VALUES('90232','Culver City','CA',1);
INSERT INTO POSTALCODES VALUES('33487','Boca Raton','FL',1);
INSERT INTO POSTALCODES VALUES('06602','Bridgeport','CT',1);