INSERT
更新时间：2024-02-23
INSERT 语句用于向表中插入数据，本文介绍了相关语法及限制。
语法
Plain Text
1INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE]
2 [INTO] tbl_name
3 [(col_name [, col_name] ...)]
4 {VALUES | VALUE} (value_list) [, (value_list)] ...
5 [ON DUPLICATE KEY UPDATE assignment_list]
6
7INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE]
8 [INTO] tbl_name
9 SET assignment_list
10 [ON DUPLICATE KEY UPDATE assignment_list]
11
12INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE]
13 [INTO] tbl_name
14 [(col_name [, col_name] ...)]
15 SELECT ...
16 [ON DUPLICATE KEY UPDATE assignment_list]
17
18value:
19 {expr | DEFAULT}
20
21value_list:
22 value [, value] ...
23
24assignment:
25 col_name = value
26
27assignment_list:
28 assignment [, assignment] ...语法限制
不支持使用以下语法。
PARTITION语法，例如：
Plain Text
1INSERT INTO test_tbl PARTITION (p0) (id) VALUES(2);相关参考
MySQL INSERT 语法。