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 WHEREname = 'AQA GCSE Spanish Higher' ANDforeign_word = 'campo, el' ANDenglish_meaning = 'field, the'