找出REPLACE语句是否已替换或刚刚插入MySQL [英] Find out if REPLACE statement has replaced or just inserted in MySQL

问题描述

MySQL中是否有一种方法可以找出最后一个REPLACE语句是否实际上替换了任何行还是只是执行了常规插入? LAST_INSERT_ID()似乎无济于事，因为在所有情况下自动更新计数器都会更新.

Is there a way in MySQL to find out if the last REPLACE statement actually replaced any row or just performed a regular insert? LAST_INSERT_ID() doesn't seem to help, since the autoincrement counter is updated in all cases.

推荐答案

REPLACE 返回受影响的行数.可以通过ROW_COUNT()在SQL中进行检索.

REPLACE returns the count of affected rows. This can be retrieved in SQL by ROW_COUNT().

这篇关于找出REPLACE语句是否已替换或刚刚插入MySQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！