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)

3. 修改

5. 期末复习

Last modified 3yr ago