SQL

sql update insert and delete

SELECT fieldname FROM tablename WHERE fieldname = ...

DELETE FROM tablename WHERE fieldname = ...

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

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

sql update insert and delete

INSERT INTO tableName
(column1, column2, ...)
VALUES (value1, value2, ...)

UPDATE tableName
SET column1=value1, column2=value2,...
WHERE filterColumn=filterValue

DELETE tableName
WHERE  filterColumn=filterValue;