sqlite – 如何在一个语句中更新两列?
发布时间:2020-12-12 19:14:06 所属栏目:百科 来源:网络整理
导读:一次更新2列? 我尝试了以下语句,这不行: UPDATE exercisesSET times_answered = times_answered + 1AND av_answeringTime = av_answeringTime + ( (av_answeringTime / (times_answered) ) + ?) * (times_answered + 1)WHERE name = ? 使用逗号而不是你的
一次更新2列?
我尝试了以下语句,这不行: UPDATE exercises SET times_answered = times_answered + 1 AND av_answeringTime = av_answeringTime + ( (av_answeringTime / (times_answered) ) + ?) * (times_answered + 1) WHERE name = ?使用逗号而不是你的“AND”: UPDATE exercises SET times_answered = times_answered + 1,av_answeringTime = av_answeringTime + ( (av_answeringTime / (times_answered) ) + ?) * (times_answered + 1) WHERE name = ? (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |