Hello Everyone,
Can someone tell me If you can find out if the replace into function has
done an insert or an update?
Thanxx
Bjorn
TTV The Victory
http://www.thevictory.nl
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMA
On Mon, 7 Feb 2005, Bjorn van der Neut wrote:
> Hello Everyone,
>
> Can someone tell me If you can find out if the replace into function has
> done an insert or an update?
It actually never does an update, it always INSERTs.
It either does an insert or delete(s) followed by an insert.
--
MySQ
It simple...
if mysql_affected_rows == 2 ---> update (because replace make DELETE and
INSERT)
else if mysql_affected_rows == 1 > insert
Gabriel PREDA
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTEC