lyfz_repos/经典版源码/document/数据库维护脚本/修改订单日期.sql

use [db]

update dindan set time1 = replace(time1, '2016-03-26', '2016-03-25'),
time2 = replace(time2, '2016-03-26', '2016-03-25'),
time4 = replace(time4, '2016-03-26', '2016-03-25'),
time5 = replace(time5, '2016-03-26', '2016-03-25'),
time6 = replace(time6, '2016-03-26', '2016-03-25') 
where id like '20160326%'

update dindanjd set date = replace(date, '2016-03-26', '2016-03-25'),
bookingdate = replace(bookingdate, '2016-03-26', '2016-03-25') where id like '20160326%'

update dindansp set date3 = replace(date3, '2016-03-26', '2016-03-25'),date4 = replace(date4, '2016-03-26', '2016-03-25') where id like '20160326%'

update dindansp2 set date = replace(date, '2016-03-26', '2016-03-25') where id like '20160326%'

update dindanbukuan set date = replace(date, '2016-03-26', '2016-03-25') where id like '20160326%'

update dindanbukuan2 set date = replace(date, '2016-03-26', '2016-03-25') where id like '20160326%'