drop table customer2; | |
CREATE TABLE customer2 ( | |
SSN VARCHAR(9), | |
lastName VARCHAR(24), | |
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); | |