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

COMPUTER SOFTWARE APPLICATION - CITS































           8  Modify Data:
           Use the UPDATE command:
           UPDATE table name SET column name = new value WHERE condition;
           Replace:

           table name with the name of your table.
           column name with the name of the column you want to update.
           new value with the new data for the column.
           condition specifies which rows to update (e.g., WHERE id = 1).




























           9  Delete Data:
           Use the DELETE FROM command:
           DELETE FROM table name WHERE condition;
           Replace:
           table name with the name of your table.

           condition specifies which rows to delete (e.g., WHERE age > 30).




                                                           62
                               CITS : IT & ITES - Computer Software Application - Exercise 20
   72   73   74   75   76   77   78   79   80   81   82