🤓
🤓
🤓
🤓
blog-article
GitHubBlog
Search
⌃K
Links
Introduction
面试题
Personal Works
CSS动画笔记
css 笔记
html 笔记
webpack4
javascript
npm
Node.js
SQL
1. 查询
2. 插入
3. 修改
4. 删除
5. 期末复习
Git
vue-cli
uni-app
设计模式
Spring boot
IDEA
Linux
shell
Docker
嵌入式系统给结构及原理
学校课程笔记
Powered By GitBook

3. 修改

-- 普通修改
UPDATE test SET hours=12.1 WHERE essn ='123456789'
​
-- 带子查询的修改
UPDATE test SET hours = (SELECT MAX(hours) FROM works_on) WHERE essn = '123456789'
Previous
2. 插入
Next
4. 删除
Last modified 3yr ago
Copy link