When a table is created it an an empty strutre. To add data to the table, the INSERT command is used.
If there are exactly the same number of values as there are fields and the values are their values have a one- to – one correspondence, i.e., the first value in inserted into the first column,the second value into the second column and so on. The queryfor inserting a row in the table is:
INSERT INTO student VALUES (1, ‘ANITA Saxena’, 10 ‘A’ ‘2010-01-18’, 450);
To view the table with the inserted record, the query is;
SELEXT FROM student;
Fig 3.11 shows both above commands.
