Page 89 - Computer Software Application TP - Volume 1
P. 89
COMPUTER SOFTWARE APPLICATION - CITS
3 Create User:
CREATE USER ‘new user’@’localhost’ IDENTIFIED BY ‘user password’;
4 Drop User:
DROP USER ‘new user’@’localhost’;
TASK 4 : Using DML (Data Manipulation Language) Statements:
1 INSERT: Adds new data to a table.
INSERT INTO departments (id, name) VALUES (4, ‘Operation’);
74
CITS : IT & ITES - Computer Software Application - Exercise 23
