Question: MYSQL VIEW ? Hi, can someone please help me check my answer for this query: Create a view that lists the first name and phone
MYSQL VIEW ?
Hi, can someone please help me check my answer for this query:
Create a view that lists the first name and phone number of the contact person at each vendor. Dont include the vendors ID in the view. Name the view contact. Change the contact view so that no users can accidentally perform DML operations on the view. Write a SELECT statement that returns all the columns from the contact view.


disabled store id store id region_id region_name order id customer id employee_id store_id order_date ship_amount tax_amount ship_date shipping_address_idINT(4) card type card_number card_expires billing_address_id orderid VARCHAR(10) VARCHAR(3) CHAR(5) CHAR(5) CHAR(25) INT(4) INT(4) INT(4) VARCHAR(3) DATETIME DECIMAL(10,2) DECIMAL(10,2) DATETIME STORE PK PK FK FK FK ORDERS CUSTOMER EMPLOYEE STORE VARCHAR(50) CHAR(16) VARCHAR(7) INT(4) INT(4) ORDERITEMS PK ORDERS FK itemid product_id quantit item_price discount amount employee_id store_id first name last name phone email salary mgr INT(4) INT(4) INT(3) DECIMAL(10,2) DECIMAL(10,2) INT(4) VARCHAR(3) CHAR(25) CHAR(25) CHAR(12) VARCHAR(100) DECIMAL(10,2) INT(4) INT VARCHAR(255) CHAR(255) CHAR(255) CHAR(255) FK PRODUCT EMPLOYEE PK FK STORE UNIQUE ADMINISTRATORS admin id PK email_address password first name last_name
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
