INSERT命令允许多个值和多行：

The INSERT command allows multiple values and multiple rows:

INSERT INTO table_name (column1, column2, ...) 
VALUES (value1, value2, ...) 
       (nextvalue1, nextvalue2, ...)

请参阅OriginalGriff的solution1和我对他的回答的评论。



我建议使用这样的东西：

Please, see solution1 by OriginalGriff and my comment to His answer.

I'd suggest to use something like this:

INSERT INTO TableName (TextField1, NumericField2, ..., FieldN)
SELECT TextField1, NumericField2, ..., FieldN
    FROM (
    SELECT 'SomeText' AS TextField1, 123 AS NumericField2, ..., FieldN
    UNION ALL
    SELECT 'SomeOtherText' AS TextField1, 456 AS NumericField2, ..., FieldN
    UNION ALL
    SELECT 'AnotherText' AS TextField1, 789 AS NumericField2, ..., FieldN
) AS Src

如需了解更多信息，请参阅：

INSERT（sql） [ ^ ]

INSERT EXAMPLES（sql） [ ^ ]