Page 103 - Computer Software Application TP - Volume 1
P. 103
COMPUTER SOFTWARE APPLICATION - CITS
2 You can remove multiple items at once with DELETE by manipulating the selection criteria specified
in the WHERE clause.
For instance, to remove multiple rows by ID, you could type something like this:
Ex - DELETE FROM employee
WHERE employee id in (3,4);
3 You can even leave out the WHERE clause to remove all of the rows from a given table:
DELETE FROM employee;
Questions
1 How can you insert multiple records in a single query?
2 How can you update multiple columns in a single query?
3 How do you delete a specific record from a table?
88
CITS : IT & ITES - Computer Software Application - Exercise 27