Android sqlite增加列值

我正在尝试将值连续增加5.我已经在此处和Google进行过搜索,但到目前为止尚未找到并回答该问题.以下是Eclipse中出现最少错误的地方.

private static String[] table_scores = {DHObject.TABLE_SCORES,};
private static String[] column_tokens = {DHObject.COLUMN_TOKENS,};
private static String[] column_points = {DHObject.COLUMN_POINTS,};
private static String[] column_num = {DHObject.COLUMN_NUM,};

public Cursor onCorrectAnswer() {
    rawQuery(table_scores, [column_tokens = column_tokens + 5], column_num 0);
    rawQuery(table_scores, [column_points = column_points + 5], column_num 0);
}

解决方法:

要增加列的值,您必须执行以下SQL语句：

UPDATE Scores
SET Tokens = Tokens + 5,
    Points = Points + 5
WHERE Num = 0;

【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！