使用MySQL查询命令和WHERE函数节省时间 [英] Saving time by using MySQL query command and the WHERE function

问题描述

我有一个包含一些产品的数据库。我可以通过命令用SQL查询更新其中一个

产品

I have a database with some products in it. I can update one of the
products with a SQL query by the command

展开 | < span class =codeLinkonclick =selectAll（this）;>选择 | 换行 | 行号

推荐答案

展开 | 选择 | Wrap | 行号

谢谢兔子！这有效。

假设我有100个产品的'id''1-100，大多数是7.99（价格），每隔一段时间就有一个14.99的产品。 'id''范围


我想改变7.99到3.99列出的价格以及在'id''范围内列出的14.99到6.99的价格-100


我知道我可以使用UPDATE和BETWEEN等函数，例如

Lets say I have 100 products with ''id'' 1-100 that are mostly 7.99 (price) and every once in a while have a product for 14.99 in that ''id'' range

I would like to change the price of the ones listed at 7.99 to 3.99 and the ones listed at 14.99 to 6.99 within that ''id'' range of 1-100

I know I can use the UPDATE and BETWEEN function such as

展开 | 选择 | 换行 | 行号

这篇关于使用MySQL查询命令和WHERE函数节省时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！