升级包脚本.sql 248 B

123456
  1. update dindansp set [no]=replace([no],'|',','),[no2]=replace([no2],'|',',')
  2. update dindan set [delphotos]=replace([delphotos],'|',';'),[delphotos2]=replace([delphotos2],'|',';')
  3. select no,no2 from dindansp
  4. select delphotos,delphotos2 from dindan