
use mytools;
DROP TABLE IF EXISTS customers;

CREATE TABLE customers (cust_id INTEGER, first_name VARCHAR(20), last_name VARCHAR(20), home_address VARCHAR(20), city VARCHAR(20), state VARCHAR(20), zip_code VARCHAR(10));

INSERT INTO customers 
VALUES (1000,'John','Smith','123 Main St','Fremont','CA','94123');

INSERT INTO customers 
VALUES (2000,'Jane','Jones','456 Front St','Fremont','CA','95015');

