在SQLite中插入多行

发布时间：2020-12-12 19:04:13 所属栏目：百科来源：网络整理

导读：我试图在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

我试图在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","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

由于您提到最新版本的SQLite,您应该使用多值插入(SQLite自版本3.7.11以后支持),如下所示：

INSERT INTO mytable (col1,col2,col3) VALUES
    (1,2,"abc"),(2,4,"xyz"),(3,5,"aaa"),(4,7,"bbb");

这是更短,更快,更不容易出错.一些其他数据库(至少MySQL和PostgreSQL)也支持这种语法.

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!