derby.create.simplebank.sql

来自「一个java写的加密算法」· SQL 代码 · 共 19 行

drop table customer2;

create table customer2 (
  SSN varchar(9), 
  lastNAme varchar(20), 
  firstname varchar(20), 
  address1 varchar (20), 
  address2 varchar(20), 
  city varchar(10), 
  state varchar(10), 
  zipcode varchar(5), 
  savingsbalance Numeric(10),
  checkingbalance Numeric(10) 
)
;

insert into customer2 values ('123456789', 'Smith', 'Rob', '1111', 'First Street', 'San Jose', 'CA', '12345', 5123, 1234);