Question

please give me proper answer

Answer 1

(i)

Creαte table Vendor(VendorID int(4) Primary Key, Name vαrchαr(20), DateOfReg date, Location vαrchαr(30));

Insert into Vendor values(1001, 'Amita', '20-01-2009', 'Delhi');

Insert into Vendor values(1002, 'Simran', '01-04-2015', 'Gujarat');

Insert into Vendor values(1003, 'Neha', '12-05-2004', 'Mumbai');

(ii) Select VendorID, Name from Vendor where Location = 'Gujarat';

(iii) Update Vendor set Location = 'Delhi' where Location = 'Gujarat';

• Create table is a DDL command used to create tables.
• Insert into is a DML command used to insert records into the table.
• Select is a query used to display information from the table.
• Update tableis a DML command used to changes values in the table.