Page 162 - Trackpad_ipro 4.1_Class7
P. 162

.....

                      .....
                      column_nameN data_type (size)
                      );
                  While creating a table in SQL, it is necessary to give a data type for each field/column. Let us create a
                  table named Student having StudentId, FirstName, LastName, and Marks  fields in the following way:

                      CREATE TABLE Student
                      (

                      StudentID INTEGER,
                      FirstName CHAR(30),
                      LastName CHAR(30),

                      Marks INT
                      );
                  In the preceding code,  you have noticed that  a value 30 is given with the CHAR data  type
                  within the parenthesis as its size. The meaning of 30 is that you can store a string value upto
                  30 characters in the FirstName and LastName fields. Whether you store a single character or 30
                  characters, this field will occupy space required for 30 characters. If you store one character, 29
                  blank spaces will be inserted with the character.


                   i +   INSERTING RECORDS IN A TABLE

                  After creating a table, you can insert records into it by using the INSERT command. The syntax to
                  insert a record into a table is:
                      INSERT INTO table_name

                      VALUES ('val_column1', 'val_column2', ... , 'val_columnN');

                  Let us insert the following records in the Student table:
                       StudentID                FirstName                 LastName                    Marks

                          10001          Amit                       Sharma                             450
                          10002          Divya                      Kaushik                            480
                          10003          Aadarsh                    Kumar                              475

                  To insert above records, we use the following commands:
                      INSERT INTO Student VALUES (10001, 'Amit', 'Sharma', 450);

                      INSERT INTO Student VALUES (10002, 'Divya', 'Kaushik', 480);
                      INSERT INTO Student VALUES (10003, 'Aadarsh', 'Kumar', 480);

                   i +   RETRIEVING RECORDS FROM TABLE

                  The SELECT command retrieves zero or more rows from a table. It helps us join information from
                  different tables and filter specific information as per the required criteria. The SELECT command
                  is the most useful DML command.



                   160     iPro (Ver. 4.1)-VII
   157   158   159   160   161   162   163   164   165   166   167