SQL声明语句出现错误

Question

使用android中的SQLite，然后运行时遇到问题：UPDATE vocab_words SET correct = 5 WHERE    name = 'AQA GCSE Spanish Higher',    foreign_word = 'campo, el',    english_meaning = 'field, the'请高手帮忙解决，谢谢。

Answer 1

UPDATE vocab_words SET correct = 5 
WHERE
name = 'AQA GCSE Spanish Higher' AND
foreign_word = 'campo, el' AND
english_meaning = 'field, the'