INSERT INTO pos_t_saleflow ( oper_date,trade_date, item_clsno, pool_flag, item_subno ) VALUES ('2015-09-05 07:47:30.847','20150905','310306','Y','6924951480572')
INSERT INTO pos_t_saleflow ( oper_date, trade_date, item_clsno, pool_flag, item_subno,) VALUES ('2015-09-05 07:50:59.887','20150905','300103','Y','6927941011800')
如这些数据,批量写入临时表,然后批量修改其中'2015-09-05 07:47:30.847' 前面的日期 如'2015-09-06 07:47:30.847' 和'20150905' 变成'20150906' 符合条件的都改变日期写入临时表,然后在插入正式表,在写入临时表修改到'20150907' 然后在写入到正式表,如此循环,改如何实现?
哦 谢谢 我试试