INSERT

使用 INSERT 语句在表中插入新行。

语法图

InsertIntoStmt

TableOptimizerHints

PriorityOpt

IgnoreOptional

IntoOpt

TableName

PartitionNameListOpt

InsertValues

OnDuplicateKeyUpdate

1. InsertIntoStmt ::=
2. 'INSERT' TableOptimizerHints PriorityOpt IgnoreOptional IntoOpt TableName PartitionNameListOpt InsertValues OnDuplicateKeyUpdate

4. TableOptimizerHints ::=
5. hintComment?

7. PriorityOpt ::=
8. ( 'LOW_PRIORITY' | 'HIGH_PRIORITY' | 'DELAYED' )?

10. IgnoreOptional ::=
11. 'IGNORE'?

13. IntoOpt  ::= 'INTO'?

15. TableName ::=
16. Identifier ( '.' Identifier )?

18. PartitionNameListOpt ::=
19. ( 'PARTITION' '(' Identifier ( ',' Identifier )* ')' )?

21. InsertValues ::=
22. '(' ( ColumnNameListOpt ')' ( ValueSym ValuesList | SelectStmt | '(' SelectStmt ')' | UnionStmt ) | SelectStmt ')' )
23. |   ValueSym ValuesList
24. |   SelectStmt
25. |   UnionStmt
26. |   'SET' ColumnSetValue? ( ',' ColumnSetValue )*

28. OnDuplicateKeyUpdate ::=
29. ( 'ON' 'DUPLICATE' 'KEY' 'UPDATE' AssignmentList )?

示例

1. CREATE TABLE t1 (a INT);

1. Query OK, 0 rows affected (0.11 sec)

1. CREATE TABLE t2 LIKE t1;

1. Query OK, 0 rows affected (0.11 sec)

1. INSERT INTO t1 VALUES (1);

1. Query OK, 1 row affected (0.02 sec)

1. INSERT INTO t1 (a) VALUES (1);

1. Query OK, 1 row affected (0.01 sec)

1. INSERT INTO t2 SELECT * FROM t1;

1. Query OK, 2 rows affected (0.01 sec)
2. Records: 2  Duplicates: 0  Warnings: 0

1. SELECT * FROM t1;

1. +------+
2. | a    |
3. +------+
4. |    1 |
5. |    1 |
6. +------+
7. 2 rows in set (0.00 sec)

1. SELECT * FROM t2;

1. +------+
2. | a    |
3. +------+
4. |    1 |
5. |    1 |
6. +------+
7. 2 rows in set (0.00 sec)

1. INSERT INTO t2 VALUES (2),(3),(4);

1. Query OK, 3 rows affected (0.02 sec)
2. Records: 3  Duplicates: 0  Warnings: 0

1. SELECT * FROM t2;

1. +------+
2. | a    |
3. +------+
4. |    1 |
5. |    1 |
6. |    2 |
7. |    3 |
8. |    4 |
9. +------+
10. 5 rows in set (0.00 sec)

MySQL 兼容性

INSERT 语句与 MySQL 完全兼容。如发现任何兼容性差异，请尝试 TiDB 支持资源。

另请参阅

• DELETE
• SELECT
• UPDATE
• REPLACE