首頁 > 資料庫 > mysql教程 > mysql累积

mysql累积

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
發布: 2016-06-07 16:26:50
原創
1170 人瀏覽過

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

相關標籤:
本網站聲明
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn
最新問題
linux安裝mysql報錯
來自於 1970-01-01 08:00:00
0
0
0
mysql 升級後無法重新啟動mysql服務的問題
來自於 1970-01-01 08:00:00
0
0
0
MySQL停止進程
來自於 1970-01-01 08:00:00
0
0
0
phpstudy不能啟動mysql?
來自於 1970-01-01 08:00:00
0
0
0
環境中mysql
來自於 1970-01-01 08:00:00
0
0
0
熱門教學
更多>
最新下載
更多>
網站特效
網站源碼
網站素材
前端模板