每日归档： 2013年10月8日

其实也是substring拉～用法和php一样substring(str,start,end )

update  test   set  Name=substring(Name,1,length(Name)-4);

流程纪录：

1.delete_issue

    a.delete_campaign_issue_info //删除voucher_campaign_issue里对应voucher_id的内容

    b.delete_voucher_action          //删除voucher_action里对应voucher_id的内容

2.issue

    a.update_vouchers_data_by_voucher_id

    b.insert_voucher_action

    c.insert_campaign_issue_info

 

执行操作如下：

UPDATE voucher SET transfer_channel = 2 where voucher_id BETWEEN 467880 AND 467954

update voucher_campaign_issue set remarks = concat(remarks,'<br>Payment: Cash') where voucher_id  BETWEEN 467880 AND 467954