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!