Page 101 - Computer Software Application TP - Volume 1
P. 101

COMPUTER SOFTWARE APPLICATION - CITS



           4  Using INSERT to add multiple rows at once
           INSERT INTO my table(column name, column name 2)

           VALUES
               (‘value’, ‘value2’),
               (‘value3’, ‘value4’),
               (‘value5’, ‘value6’);
           Ex - INSERT INTO employee(first name, last name)

           VALUES
               (‘Abigail’, ‘Spencer’),
               (‘Tamal’, ‘Wayne’),
               (‘Katie’, ‘Singh’),
               (‘Felipe’, ‘Espinosa’);


















           For show the records
           SELECT * FROM employee;





















           TASK 2 : Using update query
           Update Query:
           UPDATE your table name
           SET column1 = ‘new value1’, column2 = ‘new value2’
           WHERE condition;











                                                           86
                               CITS : IT & ITES - Computer Software Application - Exercise 27
   96   97   98   99   100   101   102   103   104   105   106