sql -如果列中不存在列值,则插入该列值的查询
发布于 2009-12-10 20:07:33
嗯。您想要新的一行吗?在这种情况下,
IF NOT EXISTS(SELECT 1 FROM emp WHERE fruits = 'mango')
INSERT INTO emp (fruits) VALUES ('mango')发布于 2009-12-10 20:25:08
有两种方法
1.IF NOT EXISTS (SELECT fruit FROM emp WHERE fruit='mango')
BEGIN
INSERT INTO emp(fruit) Values('mango');
END
2.INSERT INTO emp ('mango') SELECT distinct fruit FROM emp WHERE not exists (select fruit from emp as e Where emp.fruit = e.fruit);https://stackoverflow.com/questions/1880514
复制相似问题