Skip to main content

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>>









Comments

Popular posts from this blog

INDEX

                                                                                   INDEX      No.     Article                                                                       1.     Introduction of SQL           2.     Table Basic           3.     Keys and Constraints           4.     Referential integrity           5.     INDEX           6.     VIEW         ...

14. Ordering Results

ORDER BY used to sort the result-set by one or more columns. It Sorts the records in ascending order by default. To sort the records in a descending order, you can use the DESC keyword. SELECT column_name , column_name FROM table_name ORDERBY column_name ASC | DESC , column_name ASC | DESC ; SELECT * FROM Customers ORDERBY Country DESC ;      <<Prev                                                                                      Next>>