如果查询语句包含'？‘，正确的语法是什么？

Question

我使用SQLite管理器firefox插件执行这个查询语句。

查询语句为：

INSERT INTO "main"."bibles" ("scripture","chapter","verse","content")
VALUES("NINGPAWT NINGHPANG"," 22","2 "," Shaloi Karai Kasang gaw, \'Nang tsawra ai, na shadang sha shingtai Isak hpe woi nna Moria ga de sa wa su; ngai nang hpe madun na ra de ai bum hta shi hpe wan nat hkungga di nna nawng e,\" ngu wu ai. ");

SQLite管理员警报是：

SQLiteManager: Likely SQL syntax error: INSERT INTO "main"."bibles" ("scripture","chapter","verse","content")
  VALUES("NINGPAWT NINGHPANG"," 22","2 "," Shaloi Karai Kasang gaw, \'Nang tsawra ai, na shadang sha shingtai Isak hpe woi nna Moria ga de sa wa su; ngai nang hpe madun na ra de ai bum hta shi hpe wan nat hkungga di nna nawng e,\" ngu wu ai. ");
[ near "ngu": syntax error ]
Exception Name: NS_ERROR_FAILURE
Exception Message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]

我的查询语句是否正确？正确的说法是什么？

Answer 1

SQLite有不同的引号转义。

不要像\'那样逃避'，而要像''那样逃避

不要像\"那样逃避"，而要像""那样逃避