MySQL 现在有张表Temp,如图,想把字段中逗号全部给去掉,请问该怎么处理?谢谢

2025-02-23 05:18:31
推荐回答(1个)
回答1:

update 表名 set attr3= replace(attr3,",","");
update 表名 set attr4= replace(attr4,",","");
update 表名 set attr5= replace(attr5,",","");