select count(*) into i from basic_fileinfo where name='2'; if i=0 then insert into basic_fileinfo(id,name) values('1','2'); end if 使用这个是提示缺少关键字,是怎么问题啊?求指教???
id 是 字符类型?values(1,'2')
insert into basic_fileinfo(id,name) select distinct '1','2' from basic_fileinfo where '2' not in (select name from basic_fileinfo)
if i=0 then
insert into basic_fileinfo(id,name) values('1','2');
end if
使用这个是提示缺少关键字,是怎么问题啊?求指教???
select distinct '1','2' from basic_fileinfo where '2' not in (select name from basic_fileinfo)