×
Night mode
Sign up
Login
ON DUPLICATE KEY UPDATE
Updates 
paramVal
field if the row exists, otherwise inserts as a new row
INSERT INTO sysData (paramName, paramVal) 
VALUES ('payprocess', 1) 

ON DUPLICATE KEY 

UPDATE paramVal = 1 WHERE paramName = 'payprocess';
by Valeri Tandilashvili
4 years ago
MySQL
UPDATE
1
Pro tip: use ```triple backticks around text``` to write in code fences