MySQL

INSERT INTO VALUE / VALUES

VALUE is a synonym for VALUES in this context. Neither implies anything about the number of values lists, nor about the number of values per list. Either may be used whether there is a single values list or multiple lists, and regardless of the number of values per list.

在这里，VALUE是VALUES的同义词。两者都不意味着值列表的数量，也不意味着每个列表的值的数量。无论是否有单个值列表或多个列表，也无论每个列表的值数如何，都可以使用二者。

INSERT Statement

TRUNCATE

TRUNCATE TABLE empties a table completely. It requires the DROP privilege. Logically, TRUNCATE TABLE is similar to a DELETE statement that deletes all rows, or a sequence of DROP TABLE and CREATE TABLE statements.
Truncate operations drop and re-create the table, which is much faster than deleting rows one by one, particularly for large tables.

TRUNCATE TABLE可以完全清空一个表。它需要有DROP权限。在逻辑上，TRUNCATE TABLE类似于删除所有记录的DELETE语句，或者是一连串的DROP TABLE和CREATE TABLE语句。
TRUNCATE操作DROP并重新创建表，这比逐一删除行要快得多，特别是对于大表来说。

TRUNCATE TABLE Statement