UPDATE table SET COL_B=REPLACE(COL_B,',u','');UPDATE table SET COL_B=REPLACE(COL_B, 'u', '');UPDATE table SET COL_B=REPLACE(COL_B, ',k', '');UPDATE table SET COL_B=REPLACE(COL_B, 'k', '');--记得先备份 ...
怎么更新mysql表字段的值
UPDATE table SET COL_B=REPLACE(COL_B,',u','');UPDATE table SET COL_B=REPLACE(COL_B, 'u', '');UPDATE table SET COL_B=REPLACE(COL_B, ',k', '');UPDATE table SET COL_B=REPLACE(COL_B, 'k', '');--记得先备份2019-03-21
