(‘1,2,3,4,5,6,’)变成(‘1’,‘2’,‘3’,‘4’,‘5’,‘6’)
直接套这条sql就行了UPDATE tablename SET num = replace(DESCRIPTION,',',''' , ''')