从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","00:03:51.6770000","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