在MySQL中是否可以使用merge语句 [英] Is merge statement available in MySQL

问题描述

我必须在单个查询中使用INSERT和UPDATE.对于具有MERGE语句的SQL.

I have to use INSERT and UPDATE in single query. For that SQL having MERGE statement.

MySQL是否支持MERGE语句.如果支持，请提供示例.

Is MERGE statement supported in MySQL. If supported, please provide sample.

推荐答案

MERGE，但是，还有其他可行的方法:

MERGE is not supported by MySQL, However, there is other possible way of doing the same:

在重复的键更新中插入...

如果在INSERT中指定ON DUPLICATE KEY UPDATE选项 语句，并且新行在UNIQUE中导致重复值，或者 PRIMARY KEY索引，MySQL根据以下内容对旧行执行更新 新值.

If you specify the ON DUPLICATE KEY UPDATE option in the INSERT statement and the new row causes a duplicate value in the UNIQUE or PRIMARY KEY index, MySQL performs an update to the old row based on the new values.

这篇关于在MySQL中是否可以使用merge语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！