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'