4. 删除

-- 普通删除
DELETE FROM test WHERE hours =40 LIMIT 1 

-- 带子查询删除
DELETE FROM test WHERE hours in (41)

DELETE FROM test WHERE hours not in (select DISTINCT hours from works_on)

Last updated