update sys_dict_data set dict_value = lpad(dict_value,3,'0') where "length"(dict_value) = '2'
mysql将字段长度为2的字段前边增加0
最新推荐文章于 2022-10-19 17:44:19 发布
update sys_dict_data set dict_value = lpad(dict_value,3,'0') where "length"(dict_value) = '2'