yijia2413/insert.sh

Created April 22, 2019 08:48

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/yijia2413/461874aa64d51ae1b35daf927719339c.js"></script>
Save yijia2413/461874aa64d51ae1b35daf927719339c to your computer and use it in GitHub Desktop.

Download ZIP

MySQL insert duplicate key

Raw

insert into proc_runtime (vm, procname) values ('100', 'wechat.exe') on duplicate key update vm = values(vm), procname = values(procname), day_runtime =day_runtime +  values(day_runtime)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment