一条SQL语句插入大量数据 和查看某个表的字段是否有重复值

CREATE TABLE mytable(
　id INT PRIMARY KEY AUTO_INCREMENT,
　category_id INT NOT NULL DEFAULT 0,
　user_id INT NOT NULL DEFAULT 0,
　adddate INT NOT NULL DEFAULT 0
);

先插入一条数据

INSERT INTO  mytable(　category_id,　user_id,　adddate) VALUES (1,0,0);

翻倍插入数据
INSERT INTO mytable(　category_id, 　user_id,　adddate)

SELECT 　category_id, 　user_id,　adddate FROM mytable 

==========================是否有重复

SELECT * FROM xx_member GROUP BY member_id_card HAVING COUNT(*)>1