Mybaits if the data in the database is modified, if there is no new

Sometimes you get the need to modify the data in the database if there is one.

Before receiving this demand, the first idea is: first to the data query there is no this data, some words go to modify, no words to go new.

Then we found this solution: post it and share it.

Merge into Table P
using (SELECT ' ${column} ' columnfrom dual) d

On (d.column= p.column)

When the matched then UPDATE statement

When isn't matched then insert statement

This means that the database is queried for this data based on a unique identification field, and if the match is done, the update is done, and if it does not match, the new action is added.

Mybaits if the data in the database is modified, if there is no new