SQL~用insert语句添加数据不能和已有的重复

INSERT INTO t_test(Name, Value) SELECT 'testName', 'testValue' FROM DUAL WHERE 'testName' NOT IN (SELECT Name FROM t_test);

insert into temp_persion_results
select `PName`, `Dossol`, `LJID`, `Ptype`, `PWorker`, `StartTime`, `FinishTime1`, `scoreTime`, `Availability`, `RLineStr`, `ReDate`, `ReTime`, `C_ID`
from persion_results;

INSERT INTO persion_results(PName, Dossol, LJID, Ptype, PWorker, StartTime, FinishTime1, scoreTime, Availability, RLineStr, ReDate, ReTime, C_ID) SELECT PName, Dossol, LJID, Ptype, PWorker, StartTime, FinishTime1, scoreTime, Availability, RLineStr, ReDate, ReTime, C_ID FROM temp_persion_results WHERE LJID NOT IN (SELECT LJID FROM persion_results)

select 1 from temp_persion_results where temp_persion_results.LJID='00052'

还有更简单的方法：先在插入表中创建唯一索引，可以是一个字段，也可以是多个字段聚合。在插入语句中使用insert ignore into，忽略存在的数据，就可以添加不重复的记录。