Hi,

Just show the "REPLACE INTO" syntax to my colleagues (separate) and ask them what they think/expect it will do. They are
not familar with MySQL syntax so they didn't knew it before. Both expected that "REPLACE INTO" would behave exaclty the
same as "UPDATE". One note also that "REPLACE INTO" wouldn't be regular English.

When showing the "INSERT OR UPDATE" it was clear for both that it will perform first INSERT else UPDATE, because
internally it first performs UPDATE and then INSERT when needed we suggest to use "UPDATE OR INSERT".


3 votes for NOT using "REPLACE INTO", but use "UPDATE OR INSERT".

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
General database developer support:
http://www.databasedevelopmentforum.com

Firebird open source database (based on IB-OE) with many SQL-99 features:
http://www.firebirdsql.org
http://www.firebirdsql.info

Support list for Interbase and Firebird users:
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep:
news://newsgroups.firebirdsql.info