想插入一条记录,如果有则不插入,无则插入。表示由一个自增长id主键和其他几个记录:
<span style="white-space:pre"> </span>t_version(id,package_name, first,SECOND,third,forth)
原先想用insert ignore into,但是发现没有用,因为它把id也看做不同。
于是我找了网上的另外一种方法 insert … select … where not exist。
insert into t_version(package_name, first,SECOND,third,forth)
SELECT 'com.aaa',0,0,0,0 from DUAL
WHERE not EXISTS(SELECT package_name, first,SECOND,third,forth
from t_version where package_name ='com.aaa' and first = 0
and SECOND = 0 AND third = 0 and forth = 0);
其中 DUAL是临时表,不是物理表,是MySQL存在的,不能随便自己写。