android Sqlite更新操作能给我现有的值加值吗?

pxy2qtax  于 2023-10-14  发布在  Android
关注(0)|答案(1)|浏览(103)
  1. "UPDATE " + DatabaseFıelds.TABLE_NAME +
  2. " SET " + DatabaseFıelds.SUBJECT_PROGRESS + " = " +
  3. point + " WHERE " + DatabaseFıelds.SUBJECT_ID + " = " + id;

这个查询更新了我的值,但是我希望它添加到现有的值中。如何解决此问题?

lndjwyie

lndjwyie1#

我猜你想把point的值加到DatabaseFıelds.SUBJECT_PROGRESS的现有值上,对吗?你可以这样做:

  1. "UPDATE " + DatabaseFıelds.TABLE_NAME +
  2. " SET " + DatabaseFıelds.SUBJECT_PROGRESS + " = " +
  3. DatabaseFıelds.SUBJECT_PROGRESS + " + " + point +
  4. " WHERE " + DatabaseFıelds.SUBJECT_ID + " = " + id;

相关问题