我有一个表,我正在尝试更新范围记录,我尝试了多种方法,没有运气.这是我尝试过的脚本.
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是一个Integer字段.
我很感激帮助,在这里敲我的头.
最佳答案
试试这个
原文链接：https://www.f2er.com/mysql/434026.htmlUPDATE 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