REPLACE INTO //add or update?

2005-02-07 Thread Bjorn van der Neut
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

Re: REPLACE INTO //add or update?

2005-02-07 Thread Tobias Asplund
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

Re: REPLACE INTO //add or update?

2005-02-07 Thread Gabriel PREDA
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