help@plusacademics.org

1.       “XXX_Civiccenter_insert.sql” where XXX are your initials. 

1.       “XXX_Civiccenter_insert.sql” where XXX are your initials.  This is an SQL script which will insert the problem data into your database.



honeyd


12-09-20 | 15:41:35

# Insert into CivicCenter
use civiccenter;
INSERT INTO customer (name) VALUES ('Susie'), ('Lee'),('Jackson'), ('Bobby'), ('Margaret'), ('Ulysses');
INSERT INTO `opera` (customer_idcustomer,OperaName,OperaCost,PerformanceDate,Backstage)
VALUES ('1','Madame Butterfly','25','2019/1/11','NO'),
('1','La Traviata ','100','2019/10/3','NO'),
('1','Carmen','30','2019/10/10','NO'),
('2','Madame Butterfly','25','2019/10/21','NO'),
('3','Carmen','30','2019/5/12','NO'),
('3','La Nozze di Figaro ','100','2019/1/20','NO'),
('4','Carmen','30','2019/1/26','NO'),
('4','La Boheme ','50','2019/8/14','NO'),
('5','La Nozze di Figaro ','100','2019/2/22','YES'),
('5','Carmen','30','2019/5/12','YES'),
('3','Carmen','30','2019/5/12','YES'),
('6','Rigoletto','30','2019/10/21','NO')
;
select * from customer;
select * from opera;

Login to answer this question!