3. 修改

-- 普通修改
UPDATE  test SET hours=12.1 WHERE  essn ='123456789' 
​
-- 带子查询的修改
UPDATE test SET hours = (SELECT MAX(hours) FROM works_on) WHERE essn = '123456789'

2. 插入

4. 删除

Last modified 3yr ago