tp5的insertAll,执行时,自动增加2个id

浏览:3249 发布日期:2017/06/24
5.0.0 - 严重 - 已关闭
在用insertAll时,执行的sql语句:INSERT INTO `dl_show_log` (`openid` , `type` , `storeid` , `advid` , `positionid` , `time`) SELECT 'o82yoxBr-uUXNIzEAdS92JS','1',0,1000054,'1000014',1498298750 UNION ALL SELECT 'o82yoxBr-uUXNIzEAdS92JS','1',0,1000055,'1000015',1498298750 UNION ALL SELECT 'o82yoxBr-uUXNIzEAdS92JS','1',0,1000056,'1000016',1498298750 UNION ALL SELECT 'o82yoxBr-uUXNIzEAdS92JS','1',0,1000057,'1000016',1498298750 UNION ALL SELECT 'o82yoxBr-uUXNIzEAdS92JS','1',0,1000058,'1000017',1498298750

执行后,id自动增加2个值后才开始,如图

本来1203后面应该是1204,结果执行后,从1206开始的,多次测试都是这样的结果!
评论(
后面还有条评论,点击查看>>