Mysql中如何将id大于某一值,如2,的所有记录的id,减1, 再写回数据库?
如何写SQL语句?谢谢!
update table1 set id=id-1 where id>2 order by id
update tb set id=id-1 where id>2 order by id;
update table1 set id=id-1 where id>2
Mysql中怎么将id大于某一值,如2,的所有记录的id,减1, 再写回数据库
Mysql中如何将id大于某一值,如2,的所有记录的id,减1, 再写回数据库?
如何写SQL语句?谢谢!
update table1 set id=id-1 where id>2 order by id
update tb set id=id-1 where id>2 order by id;
update table1 set id=id-1 where id>2