- Create
- insert (all colunms)
insert into T values(V1,V2,V3)- insert (some columns)
insert into T(C1,C2) values(V1,V2)- Read
- select all colums from T
select * from T- select C1 and C2 from T
select C1,C2 from T- select by CONDITIONS
select * from T where CONDITIONS- select order by column C1
select * from T order by C1- Update
- update by CONDITIONS
update set C1=V2,C2=V2 where CONDITIONS- Delete
- delete all records
delete from T- delete by CONDITIONS
delete from T where CONDITIONS- Range
select * from T where C1 [not] between V1 and V2- Equal
select * from T where C1=V1 and C2<>V2- List
select * from T where C1 [not] in (V1,V2)