dpzjl68484 2016-09-26 05:21
浏览 53
已采纳

有没有办法确定行是否已更新postgres:golang

I am using postgres as my database and https://github.com/lib/pq as library. I am updating a record using prepared statement

stmt, _:= db.Prepare("UPDATE account set status='deleted' where id= $1")   
defer stmt.Close()
result, _:= stmt.Exec(accountId)
success, _:= result.RowsAffected()

And I noticed that the even if the row is already updated with the status=deleted update query always returns success=1. Is there any way we can differentiate between already updated row and not yet updated row?

  • 写回答

1条回答 默认 最新

  • dongyong5912 2016-09-26 05:37
    关注

    Yes just check in the where if the row needs updating.

    UPDATE account SET status='deleted' 
      WHERE id= $1 AND status <> 'deleted'
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 Simulink 仿真如何使用MATLAB function模块获取到仿真过程中某一仿真时刻输入到模块的函数的值?
  • ¥50 关于#微信小程序#的问题:微信小程序支持h5实现webrtc h264 h265低延迟传输渲染,能付费帮我们解决一下吗
  • ¥20 请问ansys License manager 这个问题如何解决
  • ¥15 memory.limit()' is no longer supported
  • ¥15 基于stm32f4产生两路pwm信号并可由串口通信调节
  • ¥15 C++/QT设置函数调用条件(多个功能调用同一,且各自调用条件不同)
  • ¥15 UE5样条线生成的网格UV问题
  • ¥15 如何用最短的时间大致看懂springboot+vue的项目
  • ¥15 (有偿)懂数值分析和含时变参数微分方程的来
  • ¥15 abaqus随机生成二维颗粒