如何在MySQL中更新一系列记录 [英] How to update a range of records in Mysql

问题描述

我有一个要更新范围记录的表，我尝试了多种方法，但没有运气.这是我尝试过的脚本.

I have a table that I am trying to update a range records, I have tried multiple methods with no luck. Here is the scripts I've tried.

UPDATE va_categories SET is_showing = '1' WHERE category_id IS BETWEEN 1076 AND 1412;
UPDATE va_categories SET is_showing = '1' WHERE category_id > '1076' < '1412';

category_id是一个整数字段.

The category_id is a Integer field.

在这里敲打头，我将不胜感激.

I would appreciate an help, banging my head here.

推荐答案

尝试一下

UPDATE va_categories SET is_showing = '1' WHERE category_id  BETWEEN 1076 AND 1412;

或

 UPDATE va_categories SET is_showing = '1' WHERE category_id > 1076 AND category_id < 1412

这篇关于如何在MySQL中更新一系列记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！