In this exercise you have to perform DML operations by using Insert, Update, Delete & Truncate Statements.
- Write a query to insert a record in
Customer
table.
CustomerID | CustomerName | Age | Phone | |
---|---|---|---|---|
1 | Peter | Peter@gmail.com | 28 | 234-364-2879 |
- Write an insert query to insert multiple records in
Customer
table.
CustomerID | CustomerName | Age | Phone | |
---|---|---|---|---|
2 | James | James@gmail.com | 25 | 346-238-2737 |
3 | Steve | Steve@gmail.com | 30 | 384-238-1278 |
- Write a query to update
Age
to 28 andEmail
to James@hotmail.com inCustomer
table for CustomerID=2. - Write a query to delete a record from
Customer
table where CustomerID is 3. - Write a query to delete all records from
Customer
table and make sure it cannot be rolled back.