CREATE TABLE user_temp SELECT DISTINCT(phone),phone_status FROM user INSERT INTO user_temp SELECT DISTINCT(phone),phone_status FROM user ..... 转载请注明：谷谷点程序 » mysql创建临时数据库并插入数据