Sql更新插入和删除

sql更新插入和删除

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

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

DELETE tableName
WHERE  filterColumn=filterValue;