Referring to Appendix A below, code a MySQL statement to display the item number and name for all items. APPENDIX A – Table definitions and initializations -- MySQL script to initialize a MySQL database and four tables: -- customer, detail, item, salesorder -- DROP DATABASE IF EXISTS finaldb; CREATE DATABASE finaldb; USE finaldb; CREATE TABLE customer ( c_num varchar(16), c_name varchar(128) ); CREATE TABLE detail ( d_onum varchar(16), d_inum varchar(16), d_qty int ); CREATE TABLE item ( i_num varchar(16), i_name varchar(128), i_price decimal(9,2), i_qty int ); CREATE TABLE salesorder ( s_num varchar(16), s_cnum varchar(16), s_date date ); INSERT INTO customer VALUES ('c101','Sam Paint'), ('c102','Ramon Hardware'), ('c103','Li Auto'); -- INSERT INTO detail VALUES ('s201','i301',21), ('s201','i302',22), ('s202','i302',23), ('s202','i303',24), ('s203','i303',25), ('s203','i304',26); -- INSERT INTO item VALUES ('i301','Doormat',6.00,80), ('i302','Carpet',16.00,81), ('i303','Air conditioner',160.00,82), ('i304','Microwave',60.00,83); -- INSERT INTO salesorder VALUES ('s201','c101','2020-3-11'), ('s202','c101','2020-3-12'), ('s203','c102','2020-3-13'); -- -- end of script --
Referring to Appendix A below, code a MySQL statement to display the item number and name for all items.
APPENDIX A – Table definitions and initializations
-- MySQL script to initialize a MySQL
-- customer, detail, item, salesorder
--
DROP DATABASE IF EXISTS finaldb;
CREATE DATABASE finaldb;
USE finaldb;
CREATE TABLE customer (
c_num varchar(16),
c_name varchar(128)
);
CREATE TABLE detail (
d_onum varchar(16),
d_inum varchar(16),
d_qty int
);
CREATE TABLE item (
i_num varchar(16),
i_name varchar(128),
i_price decimal(9,2),
i_qty int
);
CREATE TABLE salesorder (
s_num varchar(16),
s_cnum varchar(16),
s_date date
);
INSERT INTO customer VALUES
('c101','Sam Paint'),
('c102','Ramon Hardware'),
('c103','Li Auto');
--
INSERT INTO detail VALUES
('s201','i301',21),
('s201','i302',22),
('s202','i302',23),
('s202','i303',24),
('s203','i303',25),
('s203','i304',26);
--
INSERT INTO item VALUES
('i301','Doormat',6.00,80),
('i302','Carpet',16.00,81),
('i303','Air conditioner',160.00,82),
('i304','Microwave',60.00,83);
--
INSERT INTO salesorder VALUES
('s201','c101','2020-3-11'),
('s202','c101','2020-3-12'),
('s203','c102','2020-3-13');
--
-- end of script
--
Step by step
Solved in 5 steps with 5 images