if exists update else insert in mysql

insert into leaderboard(`user_name`,`score`) values(‘uspmca’,200) on DUPLICATE KEY update `score` = `score`+10

user_name needs to unique.

 

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *