При обновлении при удалении sql

sql обновление вставка и удаление

SELECT fieldname FROM tablename WHERE fieldname = ...

DELETE FROM tablename WHERE fieldname = ...

UPDATE tablename SET fieldname = ... WHERE fieldname = ...

INSERT IGNORE INTO tablename (fieldname, fieldname) VALUES (val, val)