INSERT INTO table2(OPENID, STARTTIME, VALIDTIME, STATUS, REMARK, INPUTBY, INPUTTIME, MODIFYBY, MODIFYTIME)
(select openID,'2017/12/03', '2017/12/10', '1', null, null, DATE_FORMAT(NOW(), '%Y/%m/%d %H:%i:%s'), null, DATE_FORMAT(NOW(), '%Y/%m/%d %H:%i:%s') from table1);
(select openID,'2017/12/03', '2017/12/10', '1', null, null, DATE_FORMAT(NOW(), '%Y/%m/%d %H:%i:%s'), null, DATE_FORMAT(NOW(), '%Y/%m/%d %H:%i:%s') from table1);