sqlite多行插入_在SQLite中插入多行

我试图在SQLite(最新版本)表中插入多行,但是会抛出一个错误

从HERE得到这个想法,这里是我的sql查询：

INSERT INTO "Track"

SELECT "Leonard Collections" AS "Album",

"Instrumental" AS "Artist",

"00:02:59.3800000" AS "Duration",

"1/1/0001 12:00:00 AM" AS "ReleasedDate",

"If You Love Me" AS "Title",

"False" AS "IsPlayableOnLocal"

UNION

SELECT "Leonard Collections",

"Instrumental",

"00:02:56.6930000",

"1/1/0001 12:00:00 AM",

"Espoir",

"False",

UNION

SELECT "Leonard Collections",

"Instrumental",

"00:03:51.6770000",

"1/1/0001 12:00:00 AM",

"Don't Cry For My Argentina",

"False"

但它会抛出

SQL logic error or missing database

near "UNION": syntax error

这是我的表结构

CREATE TABLE Track

(

ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL ,

Album VARCHAR(100) NULL ,

Artist VARCHAR(255) NOT NULL DEFAULT "Artist Unknown",

Duration VARCHAR(255) NOT NULL ,

LocalPath VARCHAR(255) NULL ,

ReleasedDate DATE NOT NULL ,

Title VARCHAR(255) NULL ,

IsPlayableOnLocal INTEGER NOT NULL ,

Rating VARCHAR(255) NULL

)

我的查询有问题吗？

任何帮助将不胜感激.

TIA