mysql去除左边“逗号”,第下

,6060,6059,0

update sys_dept set ancestors=right (ancestors,char_length(ancestors)-1) where left(ancestors,1)=',';

  

posted @ 2021-01-05 14:07  A汉克先生  阅读(888)  评论(0编辑  收藏  举报