2个mysql数据库test和test2中都有admin这个用户表,两个表结构相同。想把test中admin的信息复制到test2的admin中,如果用户名username重复时则跳过。
INSERT INTO test2.admin(username,password,groupid,dateline,count,dateline_login,status)
SELECT username,password,groupid,dateline,count,dateline_login,status FROM test.admin
WHERE NOT EXISTS(SELECT * FROM test2.admin WHERE test2.admin.username=test.admin.username)