Database-Management-Essentials/week 2/Assignment/customer_insert.sql at master · anein/Database-Management-Essentials · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
#######################
# Insert statement
#######################

INSERT INTO Customer (custNo, custName, address, internal, city, zip, state, contact, phone) VALUES
  ('C100', 'Football', 'Box 352200', TRUE, 'Boulder', '80309', 'CO', 'Mary Manager', '6857100');

INSERT INTO Customer (custNo, custName, address, internal, city, zip, state, contact, phone) VALUES
  ('C101', 'Men\'s Basketball', 'Box 352400', TRUE, 'Boulder', '80309', 'CO', 'Sally Supervisor', '5431700');

INSERT INTO Customer (custNo, custName, address, internal, city, zip, state, contact, phone) VALUES
  ('C103', 'Baseball', 'Box 352020', TRUE, 'Boulder', '80309', 'CO', 'Bill Baseball', '5431234');

INSERT INTO Customer (custNo, custName, address, internal, city, zip, state, contact, phone) VALUES
  ('C104', 'Women\'s Softball', 'Box 351200', TRUE, 'Boulder', '80309', 'CO', 'Sue Softball', '5434321');

INSERT INTO Customer (custNo, custName, address, internal, city, zip, state, contact, phone) VALUES
  ('C105', 'High School Football', '123 AnyStreet', FALSE, 'Louisville', '80027', 'CO', 'Coach Bob', '4441234');