Modifying the Database

You can use SQL queries to modify the contents of a database. If there are indices defined on the table, SQL will automatically update them to reflect the changes. If there are any data or referential integrity constraints defined, SQL will automatically enforce them.

INSERT Statements

The INSERT statement inserts a new row into an SQL table:

 INSERT INTO MyApp.Product
    (Name,SKU,Price) 
    VALUES ('Ginsu','DPV1486',22.95)

UPDATE Statements

The UPDATE statement modifies values in one or more existing rows within an SQL table:

 UPDATE MyApp.Person
     SET HairColor = 'Red'
     WHERE %ID = 435

DELETE Statements

The DELETE statement removes one or more existing rows into an SQL table:

 DELETE FROM MyApp.Person
     WHERE HairColor = 'Aqua'