Page 90 - Computer Software Application TP - Volume 1
P. 90
COMPUTER SOFTWARE APPLICATION - CITS
2 UPDATE: Modifies existing data in a table.
UPDATE departments SET name = ‘Operation’ WHERE id = 1;
3 DELETE: Removes data from a table.
DELETE FROM departments WHERE id = 4;
4 Select Data: Retrieve data from the table.
SELECT * FROM employees;
75
CITS : IT & ITES - Computer Software Application - Exercise 23 CITS : IT & ITES - Computer Software Application - Exercise 23