Insert

succeeds

Database

ignores it

Value

becomes NULL

Insert

fails due to constraint

DELETE

FirstName='Peter' FROM Persons;

DELETE

ROW FROM Persons WHERE FirstName='Peter';

DELETE

FROM Persons WHERE FirstName='Peter';

UPDATE

Persons SET LastName='Nilsen' WHERE LastName='Hansen';

MODIFY

Persons SET LastName='Nilsen' WHERE LastName='Hansen';

UPDATE

Persons SET LastName='Hansen' INTO LastName='Nilsen';

Deletes

the table

Commits

changes

Undoes

changes made in the current transaction

Saves

data permanently

SELECT

* FROM studrec ORDER BY kids DESC WHERE kids > 0;

SELECT

* FROM studrec WHERE kids > 0 ORDER BY kids;

SELECT

* FROM studrec ORDER BY kids WHERE kids > 0;

SELECT

* FROM studrec WHERE kids > 0 ORDER BY kids DESC;

INSERT

VALUES ('Jimmy', 'Jackson') INTO Persons;

INSERT

('Jimmy', 'Jackson') INTO Persons;

INSERT

INTO Persons VALUES ('Jimmy', 'Jackson');

INSERT

INTO Persons (FirstName, LastName) VALUES ('Jimmy', 'Jackson');

Modifies

table structure (columns, constraints)

Inserts

data

Deletes

a table

Selects

data

To

commit automatically

To

create indexes

To

delete data

To

roll back part of a transaction

To

enforce constraints

To

improve query performance (especially reads)

To

reduce table size

To

automatically sort data