forked from Gitlink/microservices
15 lines
522 B
SQL
15 lines
522 B
SQL
-- 设置所有首页推荐的文章排序值为最大值
|
|
SET @i := 0;
|
|
SET @maxSort = (SELECT MAX(`sort`)
|
|
FROM `ruoyi-gitlink`.`cms_doc`);
|
|
UPDATE `ruoyi-gitlink`.cms_doc
|
|
SET sort = (@i := @i + 1) * 1 + (@maxSort)
|
|
WHERE `is_homepage` = '1';
|
|
|
|
-- 设置所有首页推荐的项目排序值为最大值
|
|
SET @i := 0;
|
|
SET @maxSort = (SELECT MAX(`sort`)
|
|
FROM `ruoyi-gitlink`.`zone_project`);
|
|
UPDATE `ruoyi-gitlink`.zone_project
|
|
SET sort = (@i := @i + 1) * 1 + (@maxSort)
|
|
WHERE `is_homepage` = '1'; |