我在sqlite中出现双引号错误

我正在c / p到sqlite编辑器之后在excel中准备我的sql查询。我尝试了两种不同的编辑器,问题是相同的。例如在excel中,这就是我的查询的样子

enter image description here

enter image description here

INSERT INTO jokes_table (id,title,joke,cat,fav,bookmark)VALUES("9","There''s this dyslexic guy... he walked into a bra...","There''s this dyslexic guy... he walked into a bra...","Bar","0","0");

在sqlite编辑器中,它变成

"INSERT INTO jokes_table (id,title,joke,cat,fav,bookmark)VALUES(""1"",""What do you call a cow with no legs?

Ground Beef!"",""What do you call a cow with no legs?

Ground Beef!"",""Animal"",""0"",""0"");"

查询的开头和结尾都有多余的引号。我知道这是“底线”的情况,但是如果我手动删除多余的引号,那么如果编辑器具有底线,则可以运行代码而不会出现任何错误。有10.000个查询,我无法手动删除。我该如何解决?非常感谢

评论