introduction to databases this would return only the names of the students data manipulation language data can also be inserted into table or existing data in table can be updated this is done using the data manipulation language (dmlfor exampleto insert data into table we merely need to write an insert sql statement providing the values to be added and how they map to the columns in the tableinsert into 'students('id''name''surname''subject''email'values (' ''james''andrews''games''ja@my com')this would add the row to the table students with the result that the table would now have an additional rowupdating an existing row is little more complicated as it is first necessary to identify the row to be updated and then the data to modify thus an update statement includes where clause to ensure the correct row is modifiedupdate 'studentsset 'email'='grj@my comwhere 'id'=' 'the effect of this code is that the second row in the students table is modified with the new email address