12. INSERT UPDATE and DELETE Queries

INSERT

The INSERT INTO statement is used to insert new records in a table

INSERTINTOtable_name

VALUES (value1,value2,value3,...);

Or

INSERTINTOtable_name(column1,column2,column3,...)

VALUES (value1,value2,value3,...);

UPDATE

Used to update existing records in a table.

UPDATEtable_name

SET column1=value1,column2=value2,...

WHEREsome_column=some_value;

DELETE

Used to delete rows in a table.

DELETEFROMtable_name

WHEREsome_column=some_value;









<<Prev                                                                          Next>>