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
   84   85   86   87   88   89   90   91   92   93   94