插入SQLite的错误多行（错误code = 1） [英] Insert Multiple Rows in SQLite Error (error code = 1)

问题描述

我SQLite中的Andr​​oid

执行以下查询时收到错误

  sDataBase.execSQL（查询）;
 

  

插入联系人（身份证，名字，姓氏，联系号码，EMAILID，状态）   values('ae0caa6a-8ff6-d63f-0253-110b20ac2127','xxx','xxx','9008987887','[e-mail]','Yes'),('9afab56e-a18a-47f2-fd62-35c78d8e0d94','yyy','yyy','7890988909','[e-mail]','Yes'),('378d757a-ee60-07a4-e8bc-396b402c3270','zzz','zzz','9000898454','[e-mail]','Yes')

注意：这是执行罚款的SQLServer，在Android中得到错误 SQLite的。

 错误：sqlite的返回：错误code = 1，味精=近，：语法错误，DB = /数据/数据​​/ myapp.contactmanager /数据库/ web视图。 DB
 

修改1：我已经值之间的增值空间仍然得到错误

 插入联系人（身份证，名字，姓氏，联系号码，EMAILID，状态）值
（'ae0caa6a-8ff6-d63f-0253-110b20ac2127'，'XXX，XXX，9008987887，[e-mail]'，'是'），
（'9afab56e-a18a-47f2-fd62-35c78d8e0d94'，'YYY'，'YYY'，'7890988909'，'[e-mail]'，'是'），
（'378d757a-ee60-07a4-e8bc-396b402c3270'，'ZZZ'，'ZZZ'，'9000898454'，'[e-mail]'，'是'）
 

修改2：更改使用查询<一href="http://stackoverflow.com/questions/1609637/is-it-possible-to-insert-multiple-rows-at-a-time-in-an-sqlite-database">Is有可能在SQLite数据库一次插入多行？仍无法正常工作

  INSERT INTO与我们联系
选择ae0caa6a-8ff6-d63f-0253-110b20ac2127为ID，'XXX'AS名字，'XXX'AS姓氏，'9008987887'AS联系号码，[e-mail] EMAILID，是作为状态，
UNION SELECT9afab56e-a18a-47f2-fd62-35c78d8e0d94'，'YYY'，'YYY'，'7890988909'，'[e-mail]，是
UNION SELECT378d757a-ee60-07a4-e8bc-396b402c3270，ZZZ，ZZZ，9000898454，[e-mail]，是
 

修改3：我已经做了一个小错误，在编辑2.最终的同步状态是我已经包括前盟逗号，让我得到一个错误。现在，删除和工作正常，

  INSERT INTO与我们联系
选择ae0caa6a-8ff6-d63f-0253-110b20ac2127为ID，'XXX'AS名字，'XXX'AS姓氏，'9008987887'AS联系号码，[e-mail] EMAILID，'是的'AS状态
UNION SELECT9afab56e-a18a-47f2-fd62-35c78d8e0d94'，'YYY'，'YYY'，'7890988909'，'[e-mail]，是
UNION SELECT378d757a-ee60-07a4-e8bc-396b402c3270，ZZZ，ZZZ，9000898454，[e-mail]，是
 

解决方案

这不是你如何插入SQLite的多行。请参阅<一href="http://stackoverflow.com/questions/1609637/is-it-possible-to-insert-multiple-rows-at-a-time-in-an-sqlite-database">this帖子了解详细信息。

如果我是你，去与无论是语法，这个问题的答案或者，如果你希望能够一次过插入单行，只是做一个标准的 INSERT INTO分贝（一，二）VALUES（一，二）并执行，一旦你要插入的每一行。由你！

I am getting an error when executing the following query in SQLite Android

sDataBase.execSQL(query);

insert into Contacts(ID,FirstName,LastName,PhoneNumber,EmailId,Status) values('ae0caa6a-8ff6-d63f-0253-110b20ac2127','xxx','xxx','9008987887','[e-mail]','Yes'),('9afab56e-a18a-47f2-fd62-35c78d8e0d94','yyy','yyy','7890988909','[e-mail]','Yes'),('378d757a-ee60-07a4-e8bc-396b402c3270','zzz','zzz','9000898454','[e-mail]','Yes')

Note: This is executed fine in SQLServer, getting error in Android SQLite.

Error: sqlite returned: error code = 1, msg = near ",": syntax error, db=/data/data/myapp.contactmanager/databases/webview.db

EDIT 1: I have added space between values still getting error

insert into Contacts(ID, FirstName, LastName, PhoneNumber, EmailId,Status) values
('ae0caa6a-8ff6-d63f-0253-110b20ac2127', 'xxx', 'xxx','9008987887', '[e-mail]', 'Yes'), 
('9afab56e-a18a-47f2-fd62-35c78d8e0d94', 'yyy', 'yyy', '7890988909', '[e-mail]', 'Yes'), 
('378d757a-ee60-07a4-e8bc-396b402c3270', 'zzz', 'zzz', '9000898454', '[e-mail]', 'Yes')

Edit 2: Changed the query using Is it possible to insert multiple rows at a time in an SQLite database? still not working

INSERT INTO Contacts 
SELECT 'ae0caa6a-8ff6-d63f-0253-110b20ac2127' AS ID, 'xxx' AS FirstName, 'xxx' AS LastName, '9008987887' AS PhoneNumber, '[e-mail]' AS EmailId, 'Yes' AS Status, 
UNION SELECT '9afab56e-a18a-47f2-fd62-35c78d8e0d94', 'yyy', 'yyy', '7890988909', '[e-mail]', 'Yes' 
UNION SELECT '378d757a-ee60-07a4-e8bc-396b402c3270', 'zzz', 'zzz', '9000898454', '[e-mail]', 'Yes'

Edit 3: I have did a small mistake in the Edit 2. End of Sync status that is before UNION i have included comma, so that i got an error. Now removed and working fine.

INSERT INTO Contacts 
SELECT 'ae0caa6a-8ff6-d63f-0253-110b20ac2127' AS ID, 'xxx' AS FirstName, 'xxx' AS LastName, '9008987887' AS PhoneNumber, '[e-mail]' AS EmailId, 'Yes' AS Status 
UNION SELECT '9afab56e-a18a-47f2-fd62-35c78d8e0d94', 'yyy', 'yyy', '7890988909', '[e-mail]', 'Yes' 
UNION SELECT '378d757a-ee60-07a4-e8bc-396b402c3270', 'zzz', 'zzz', '9000898454', '[e-mail]', 'Yes'

解决方案

That's not how you insert multiple rows in SQLite. See this post for details.

If I were you, go with either the syntax in that question's answer OR, if you want to be able to insert a single row at once too, just do a standard INSERT INTO db (one, two) VALUES (one, two) and execute that once for each row you're inserting. Up to you!

这篇关于插入SQLite的错误多行（错误code = 1）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！