开发者

Help in mysql query

开发者 https://www.devze.com 2023-03-18 22:51 出处:网络
I have a database: http://d.pr/86DH+ 开发者_JS百科I want to divide all numbers in price column with 1.2 at once. It is possible?Use this:

I have a database:

http://d.pr/86DH+

开发者_JS百科I want to divide all numbers in price column with 1.2 at once. It is possible?


Use this:

UPDATE tbl SET price = price / 1.2
0

精彩评论

暂无评论...
验证码 换一张
取 消