跳转至

数据增删改

插入、更新、删除

INSERT INTO emp(last_name, age, dept_id)
VALUES
('n1', 11, 1),
('n2', 12, 2),
('n3', 11, 2)

UPDATE emp
SET last_name = 'matt', age = 99
WHERE id = 6

DELETE FROM emp
WHERE id = 6