mysql累积
程序员文章站
2022-04-04 17:24:55
...
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://*.com/questions/3164505/mysql-insert-record-if-not-exists-in-table
上一篇: jsp怎么设置刷新页面
下一篇: python字符串连接方法分析
推荐阅读
-
Win10周年累积更新KB3206632及12月全部补丁独立安装包下载
-
MySQL 双向备份的实现方法
-
MYSQL使用.frm恢复数据表结构的实现方法
-
MySQL修改innodb_data_file_path参数的一些注意事项
-
MySQL中的LOCATE和POSITION函数使用方法
-
python安装mysql-python简明笔记(ubuntu环境)
-
Starting MySQL.Manager of pid-file quit without updating file.[FAILED]的解决方法
-
Mysql 本地计算机无法启动 mysql 服务 错误 1067:进程意外终止。
-
mysql 8.0.15 下载安装详细教程 新手必备!
-
Centos7下mysql 8.0.15 安装配置图文教程