SqlServer和Mysql插入记录前判断是否存在,存在则插入,不存在则修改。
2024-09-26 20:11:21
SqlServer中是这样:
if NOT exists(SELECT * FROM Setting WHERE ID=0)
INSERT INTO Setting(ID,Title,SearchKeys, ServiceIntervalSecond,SleepMillisecondPerSearch) VALUES(0,@title,@searchKeys,@serviceIntervalSecond,@sleepMillisecondPerSearch)
ELSE
UPDATE Setting SET Title=@title,SearchKeys=@searchKeys,ServiceIntervalSecond=@serviceIntervalSecond, SleepMillisecondPerSearch=@sleepMillisecondPerSearch
MySqL中是这样:
INSERT INTO `his_examine_result` (Mid,His_Examine_Mid, His_File_Mid, ResultType, His_Employee_Mid,
His_Employee_Name, ExamineResult, ExamineItemName, ExamineStandardName,
ExamineItemUnit, ExamineHighValue, ExamineLowValue, ExamineDiscription, Discription)
VALUES ($mid,$examineMid,$fileMid,1,null,null,'',$itemName,$standName,$itemUnit,$highValue,$lowValue,'','')
ON DUPLICATE KEY UPDATE ExamineResult=$result,ExamineDiscription=$dis
最新文章
- Beginning Scala study note(5) Pattern Matching
- 关于springMVC3.0基于注解方式的项目搭建
- C#连接操作mysql实例
- loghelper.cs 代码
- 在Asp.net MVC中访问静态页面
- GitHub托管
- 05---JSON学习(Java)
- mac下安装eclipse以及python
- MySQL - 扩展性 1 概述:人多未必力量大
- AtCoder瞎做第二弹
- Android Frameworks的base目录内容分析 “Android Frameworks base”
- Git技能图
- Linux 常用命令——文件处理命令
- eclipse工具类及插件(修改eclipse.ini文件及作者名字)
- Linux之Ubuntu安装Sublime
- loj#2552. 「CTSC2018」假面
- python--json串相关的loads dumps load dump
- Myeclipse快键键
- Winform窗体控件级权限处理
- String中intern()方法