INSERT INTO `user`( `name`, `password`, `sex`, `age`, `email`, `mypage`, `salary`) SELECT `name`, `password`, `sex`, `age`, `email`, `mypage`, `salary` FROM `user`
注意,不要把主键id放进去
INSERT INTO `user`( `name`, `password`, `sex`, `age`, `email`, `mypage`, `salary`) SELECT `name`, `password`, `sex`, `age`, `email`, `mypage`, `salary` FROM `user`
注意,不要把主键id放进去
转载于:https://www.cnblogs.com/hltswd/p/5137515.html