insert into basic_fileinfo(id,name) values('1','2') where '2' not in (select name from basic_fileinfo)
此语句执行错误！错误在什么地方？
------解决方案--------------------
insert into basic_fileinfo(id,name)
select distinct '1','2' from basic_fileinfo where '2' not in (select name from basic_fileinfo)