sqlite一条语句插入多条记录

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(...)

---

参考：INSERT (sqlite.org)