Simple select:
SELECT fieldname FROM tablename
Simple SQL INSERT :
INSERT INTO tableName VALUES (value1, value2,..)
Insert specifying fieldnames :
INSERT INTO tabelnaam (fieldName1, fieldName2,..) VALUES (value1, value2,..)
Update using a SET statement (MySQL only) :
UPDATE tablename SET fieldName1='value1', fieldName2='value2'