Batch update names separated by commas (,) (multiple IDs separated by commas (,) in a department are converted into names separated by commas (,) (mysql) and comma (,) mysql

Batch update names separated by commas (,) (multiple IDs separated by commas (,) in a department are converted into names separated by commas (,) (mysql) and comma (,) mysql
Update dept B, (select group_concat (t. deptId), group_concat (d. deptName separator '/') as dName, t. id, t. deptName from (select substring_index (. deptId, ',', B. help_topic_id + 1), ',',-1) as deptId,. id,. deptName
From
(Select d. father AS deptId, d. id, d. deptName
From dept d)
Join mysql. help_topic B on B. help_topic_id <(length (. deptId)-length (replace (. deptId, ') + 1) t left join dept d on t. deptId = d. id where t. deptId! =''

Group by id, deptName) c set B. location = c. dName where B. id = c. id

Effect

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.