mysql if userid exist then INSERT else update

Question

i have a mysql table with columns like this

id
userid
userName
role

id is primary key, userid is unique

so i want to insert data to mysql from phplike this

if userid(in this case 11) is not in the db

INSERT INTO tblName (userid,userName,role) VALUES ('11','name','admin')

if this userid is exist in db then update username and role

UPDATE tblName SET userName = 'name', role = 'admin' WHERE userid=11;

See this question for the solution: https://stackoverflow.com/q/42663074/430567 — Lord Peter, Sep 21 '18 at 16:54

score 0 · Accepted Answer · answered Sep 21 '18 at 16:57

0

INSERT INTO users (userid,userName,role,userPassword,device) VALUES ('11','21','31','41','51') 
ON DUPLICATE KEY UPDATE role='0'

answered Sep 21 '18 at 16:57

arlind

score 0 · Answer 2 · answered Sep 21 '18 at 17:04

0

In your case query will be:

INSERT INTO tblName (userid, userName, role) VALUES ('11', 'name', 'admin')
 ON DUPLICATE KEY UPDATE userName = 'name', role = 'admin';

answered Sep 21 '18 at 17:04

Evgeny A. Mamonov

2 Answers2