🤓
🤓
🤓
🤓
blog-article
GitHub
Blog
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