Consider the following Vendor table and write the queries
Table Vendor
VendorID VName Date of Registration Location
V001 Mother Dairy 20-01-2009 Delhi
V002 Havmor 01-04-2015 Gujrat
V003 Amul 12-05-2012 Kolkata
V004 Kwality Walls 15-10-2013 Mumbai
(i) Write a Query to display all records
(ii) Write a Query to add a new row with the following details
(‘V005’, ‘Vadilal’, ‘20-03-2010’, ‘Pune’)
(iii) Write a query to modify the location of V003 from Kolkata to Gujr
Answers
Answered by
1
Answer:
(I) Write a Query to display all records
Similar questions