Question

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​

Answer 1

Answer:

(I) Write a Query to display all records