Page 322 - IT 402 v2.0 class 10
P. 322

Step 2:  Click on ‘Execute’ button.





                                                              1

                                                              2













         elete Statement

        ‘Delete’ statement is used to remove one or more records in a database.
            S nta   :   D E L E T E  F RO M  T AB L E _ NAM E  W H E RE  CO ND I T I O N;
              am le :    To delete records of the student who has secured 100 marks in the STUDENT table:

                        DELETE FROM STUDENT WHERE MARKS = 100;
        Step 1:  Type the statement.

        Step 2:  Click on ‘Execute’ button.




                                                              1

                                                              2














            Recap Zone

                  ata  efinition  anguage or  ata  escription  anguage       is a standard for commands that
               define the different structures in a database.
               SQL statements consist of reserved words or characters used to perform arithmetical operations,
               comparisons  etc.  hese reserved words or characters are called as  Operators .
               SQL Create Table statement is used to create a table in database. To create a table, assign a name
               to the table and then define columns and the data types of each column.
                ueries are commands that are used to define the data structure and also to manipulate the data
               in the database.  uery is used to collect specific information from the table.
                ecords can also be added  modified or deleted from the existing table using the Insert   pdate
               and Delete commands.
                 pdate  statement is used for modifying records in a database.



         320       Touchpad Information Technology-X
   317   318   319   320   321   322   323   324   325   326   327