insert into 表名(字段名1,字段名2)values(值a1,值b1), (值a2,值b2),
示例:
INSERT INTO bookinfo (
NAME,
pub_date,
readcount,
commentcount,
is_delete
)
VALUES
(
'神雕侠侣',
'1978-10-21',
100000,
30000,
FALSE
),
(
'圆月弯刀',
'1982-05-21',
80000,
12220,
FALSE
),
(
'天龙八部',
'1988-09-03',
1000000,
100000,
FALSE
)