MySQL乘法查询 [英] Mysql multiplication query

问题描述

我有一个称为商品的表，其中包含一个称为价格的字段，我只想将每种商品的价格翻一番.您能帮我一个可以在PHP myAdmin中运行的SQL语句吗?

I have a table called products containing a field called price and I simply want to double the price on every product. Could you give me a hand with an SQL statement I can run within PHP myAdmin please.

推荐答案

update products set price = price * 2;

这篇关于MySQL乘法查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！