Implicit Method: In this method we can enter the values at required columns in a table. So that we can omits some column data. If we don’t insert any value in particular column in a table then it automatically takes NULL.Syntax: insert into table_name(col1,col2,…coln) values(val1,val2,….valn); Example:

UPDATE: This command is used to modify the data in the existing table. Using this command we can modify all the records in a table and also we can modify specific records in the table (Using where clause-Discussed in the later sessions). Syntax: update table_name set column_name=value; Example:

DELETE: This command is used to delete the data in the existing table. Using this command we can delete all the records in a table and also we can delete specific records in the table (Using where clause-Discussed in the later sessions).