SQL(MSSQL)脚本代码:

IF (SELECT parentId FROM t_category WHERE categoryId = 1) IS NULL
    UPDATE t_category SET sort = sort + 1
        WHERE sort >= (SELECT sort FROM t_category WHERE categoryId = 1)
            AND parentId IS NULL
ELSE
    UPDATE t_category SET sort = sort + 1
        WHERE sort >= (SELECT sort FROM t_category WHERE categoryId = 1)
            AND parentId = (SELECT parentId FROM t_category WHERE categoryId = 1)

小弟初次接触mysql, 很多与sqlserver的差异都还不太明白, 谢谢大侠们了!