Question

VID VName Reg 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’, ‘2010-03-20’, ‘Pune’)
(iii) Write a query to modify the location of V003 from Kolkata to Gujrat.
(iv) Write a Query to delete the record of id no ‘V004’.
(v) Replace the Location as ‘Delhi’ for the id V002.
(vi) Write a query to delete the entire table Vendor.

Answer 1

Explanation:

gg vi UV cm HC CNN mcl lz bl cz cm cz cm cz do ta do y'all pal pal vaishakh