sql语句格式(在sqlite3.37.2中测试)
insert into 'DbConfig'
select '5735196270353316223' as 'Id','22' as 'DropCountVersion','1' as 'Para1','2' as 'Para2'
union select '5735196270353316224','23','1','2'
union select '5735196270353316225','24','1','2'
union select '5735196270353316226','25','1','2'
union select '5735196270353316227','26','1','2'
union select '5735196270353316228','27','1','2'
解释:
提取格式:
INSERT INTO 'tablename'
SELECT 'data1' AS 'column1', 'data2' AS 'column2'
UNION SELECT 'data3', 'data4'
UNION SELECT 'data5', 'data6'
UNION SELECT 'data7', 'data8'
其中表中的所有列名都需要列出来,如果有的列不用插入,可以把值写为NULL,如:
INSERT INTO 'tablename'
SELECT 'data1' AS 'column1', 'data2' AS 'column2',NULL AS 'column3'
UNION SELECT 'data3', 'data4',NULL
UNION SELECT 'data5', 'data6',NULL
UNION SELECT 'data7', 'data8',NULL
注意:使用此种方法插入的数据无法使用ORDER BY,LIMIT等,如果以后要对插入的数据使用这些方法,请使用Insert into table values(...)