如何减少sql中的值 [英] How to decrease a value in sql

问题描述

大家好。



我需要帮助编辑数据库表中的值。它是一个产品订阅表，我想编写一个sql查询，将订阅周期减少1例如，12个月订阅的值为12,6个月的值为6，所以我需要帮助写一个查询将所有订阅值减少1



我有这样的东西：



UPDATE TABLE订阅



添加1到sub_period





请尽快回复



谢谢

解决方案

尝试更新mytable set subscription = subscription - 1

Hello all.

I need help editing the values in a database table. Its a product subscription table, and i want to write an sql query that will decrease the subscription period by 1 e.g A 12 months subscription will have a value of 12, 6 months will have a value of 6, so I will need help to write a query to reduces all subscription values by 1

I have something like this:

UPDATE TABLE subscription

ADD 1 to sub_period


Kindly reply soon

Thank you

解决方案

Try Update mytable set subscription = subscription - 1

这篇关于如何减少sql中的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！