Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
a) Write an SQL command to Delete the record of the Customers belonging to Mexico. b) In the Customer table given above the country name of the Customer “Alfreds Futterkiste” has been inserted wrong. Write an SQL command to change it to “UK”.
Typology: Assignments
1 / 2
This page cannot be seen from the preview
Don't miss anything!
Database Systems Page 1 of 1 NOTE: Attempt all questions. Question 1 (SQL) : a) Write an SQL command to Delete the record of the Customers belonging to Mexico. b) In the Customer table given above the country name of the Customer “Alfreds Futterkiste” has been inserted wrong. Write an SQL command to change it to “UK”.
Database Systems Page 2 of 1
a) Write an SQL command to Delete the record of the Customers belonging to Mexico. Answer: DELETE FROM Customer WHERE country='mexico'; b) In the Customer table given above the country name of the Customer “Alfreds Futterkiste” has been inserted wrong. Write an SQL command to change it to “UK”. Answer: UPDATE Customers SET country = ‘UK’ WHERE CustomerName = ‘Alfreds Futterkiste
