MySQL问题

设置值自动递增排序

Posted by dm on March 25, 2020

update equipment_market_goods_profile SET sort_no = NULL;
# 设置值自动递增排序
set @num=0;
update equipment_market_goods_catagory
SET sort_no = (@num := @num + 1)
;