mysql 批量更新字段删除字段中的空格

update tgs_code set pkg=replace(pkg,’ ‘,”);
update tgs_code set riqi=replace(riqi,’ ‘,”);
update tgs_code set txm=replace(txm,’ ‘,”);
update tgs_code set bianhao=replace(bianhao,’ ‘,”);