作者:芬飞满天2011 | 来源:互联网 | 2018-06-10 19:35
mysql积累INSERTINTOt_ent_service(ent_id,service_id)SELECT*FROM(SELECT1,2)AStmpWHERENOTEXISTS(SELECT1FROMt_ent_serviceWHEREent_id1ANDservice_)AND(SELECT1FROMt_entWHEREent_id1243434312)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 (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