SQL命令存储

发布时间:2021年09月22日 阅读:120 次


update qmll_lssj_lssjjs set qmll_lssj_endtime = DATE_ADD(qmll_lssj_starttime, INTERVAL 1 DAY),scrq = DATE_ADD(qmll_lssj_starttime, INTERVAL 1 DAY),qmll_lssj_starttime =  DATE_ADD(qmll_lssj_starttime, INTERVAL 1 DAY)  where qmll_lssj_starttime like %2021-09-22%


update qmll_sjjc_eventship set scrq = DATE_ADD(qmll_sjjc_eventdate, INTERVAL 1 DAY),qmll_sjjc_eventdate =  DATE_ADD(qmll_sjjc_eventdate, INTERVAL 1 DAY)  where qmll_sjjc_eventdate like %2021-09-22%

*3  0920、0921、0922


Tag:
相关文章

发表评论: