mysql累积

mysql积累 INSERT INTO t_ent_service(ent_id,service_id) SELECT * FROM (SELECT '1','2') AS tmp WHERE NOT EXISTS (SELECT 1 FROM t_ent_service WHERE ent_id ='1' AND service_id='2') AND (SELECT 1 FROM t_ent WHERE ent_id = '1243434312') AND (SELE

mysql积累

INSERT INTO t_ent_service(ent_id,service_id) SELECT * FROM (SELECT '1','2') AS tmp

WHERE NOT EXISTS

(SELECT 1 FROM t_ent_service WHERE ent_id ='1' AND service_id='2')

AND

(SELECT 1 FROM t_ent WHERE ent_id = '1243434312')

AND

(SELECT 1 FROM t_service WHERE service_id = '2325235235235256')

?

?

?

?INSERT?INTO?t_ent_service(ent_id,service_id,service_status,licence_num,service_exp_time,service_start_time,customized_patams)?
SELECT?'1','2',1,20,'123',SYSDATE(),'备注信息'?FROM?DUAL
WHERE?NOT?EXISTS
(SELECT?1?FROM?t_ent_service?WHERE?ent_id?='1'?AND?service_id='2')
AND
(SELECT?1?FROM?t_ent?WHERE?ent_id?=?'1243434312')
AND
(SELECT?1?FROM?t_service?WHERE?service_id?=?'2325235235235256')?

?

?

http://stackoverflow.com/questions/3164505/mysql-insert-record-if-not-exists-in-table