willianzhu的博客

update bg_data_column aa,( SELECT @r:= case when @obj_id=a.obj_id then @r-1 else 200 end as rowNum, @obj_id:=a.obj_id as obj_id, a.id from bg_data_column a ,(select @r:=0 ,@obj_id:...

数据库中将汉字转换为全拼、简拼的函数方法