MySQL将假定等号之前的部分引用INSERT INTO子句中命名的列，而第二部分引用SELECt列。
INSERT INTO lee(exp_id, created_by, location, animal, starttime, endtime, entct, inact, inadur, inadist, smlct, smldur, smldist, larct, lardur, lardist, emptyct, emptydur)SELECT id, uid, t.location, t.animal, t.starttime, t.endtime, t.entct, t.inact, t.inadur, t.inadist, t.smlct, t.smldur, t.smldist, t.larct, t.lardur, t.lardist, t.emptyct, t.emptydur FROM tmp t WHERe uid=xON DUPLICATE KEY UPDATE entct=t.entct, inact=t.inact, ...
