Page 90 - Computer Software Application TP - Volume 1

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