SQL 根据IF判断,SET字段值

当INVOICE_STATUS值为1时,赋值为2,否者赋值为原来的值

UPDATE T_INVOICE SET DOWNLOAD_COUNT = DOWNLOAD_COUNT + 1, INVOICE_STATUS = IF(INVOICE_STATUS='1','2',INVOICE_STATUS)

posted @ 2018-01-30 16:46  七脉  阅读(992)  评论(0编辑  收藏  举报