**方法一:**利用VALUES(value1, value2, …),(value1, value2, …),
…(value1, value2, …),
INSERT INTO actor
VALUES
( 1, 'PENELOPE', 'GUINESS', '2006-02-15 12:34:33' ),
(
2,
'NICK',
'WAHLBERG',
'2006-02-15 12:34:33')
**方法二:**利用 UNION SELECT 批量插入
INSERT INTO actor SELECT
1,
'PENELOPE',
'GUINESS',
'2006-02-15 12:34:33' UNION
SELECT
2,
'NICK',
'WAHLBERG',
'2006-02-15 12:34:33'