Skip to content

Commit b1c2dbe

Browse files
committed
Merge branch 'main' of github.com:Snailclimb/JavaGuide
2 parents 36808d7 + dc44f21 commit b1c2dbe

File tree

1 file changed

+1
-1
lines changed

1 file changed

+1
-1
lines changed

docs/database/mysql/a-thousand-lines-of-mysql-study-notes.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -137,7 +137,7 @@ SHOW VARIABLES -- 显示系统变量信息
137137
INSERT [INTO] 表名 [(字段列表)] VALUES (值列表)[, (值列表), ...]
138138
-- 如果要插入的值列表包含所有字段并且顺序一致,则可以省略字段列表。
139139
-- 可同时插入多条数据记录!
140-
REPLACE 与 INSERT 完全一样,可互换
140+
REPLACE与INSERT类似,唯一的区别是对于匹配的行,现有行(与主键/唯一键比较)的数据会被替换,如果没有现有行,则插入新行
141141
INSERT [INTO] 表名 SET 字段名=值[, 字段名=值, ...]
142142
--
143143
SELECT 字段列表 FROM 表名[ 其他子句]

0 commit comments

Comments
 (0)