Question

Create table using SQL with the following structure:-

Table:- Vendor

VENDORID NAME DATEOFREG LOCATION

1001 Amita 20-01-2009 Delhi

1002 Simran 01-04-2015 Gujrat

1003 Neha 12-05-2004 Mumbai

(i) Create the above table

(ii) Write command to display Vendor Id and Name with Location Gujrat

(iii) Update the Location name of Gujrat with Delhi​

Answer 1

Actually, I am not able to post this answer, I am getting this error.

iii) UPDATE VENDOR SET LOCATION ="Delhi" where LOCATION = "Gujarat"