请教一句MYSQL的写法INSERT INTO `present_list`INSERT INTO `present_list`
INSERT INTO `present_list`
(`SendSN`, `SendNick`, `RecvSN`, `RecvNick`, `ItemID`,`Period`, `SendDate`, `Msg`)
SELECT DISTINCT uwc.UserSN, ui.UserNick, uwc.UserSN, ui.UserNick, uwc.ItemID, 30,'$date', '简单娱乐网.祝您玩的愉快!'
FROM basket uwc
LEFT JOIN audition.userinfo ui
ON ui.UserSN = uwc.UserSN
WHERE uwc.UserSN = '$usersn'
其中需要再加两个字段 一个是PresentID 另外一个是 OrderID
PresentID 是自动递增字段
如何使 OrderID = PresentID
有人说用LAST_INSERT_ID 获得哪个自动递增的编号。然后在进行Update