MySQL Insert on Duplicate Key Update
All- What is the opinion regarding the use of MySQL's syntax for: INSERT .... ON DUPLICATE KEY UPDATE http://dev.mysql.com/doc/refman/4.1/en/insert-on-duplicate.html I haven't seen any code that uses it. Is that habit or policy? - Ken Rickard agentrickard
One word: PostgreSQL. On 9/6/06, Ken Rickard <agentrickard@gmail.com> wrote:
All-
What is the opinion regarding the use of MySQL's syntax for:
INSERT .... ON DUPLICATE KEY UPDATE
http://dev.mysql.com/doc/refman/4.1/en/insert-on-duplicate.html
I haven't seen any code that uses it. Is that habit or policy?
- Ken Rickard agentrickard
Ken Rickard wrote:
What is the opinion regarding the use of MySQL's syntax for:
INSERT .... ON DUPLICATE KEY UPDATE
http://dev.mysql.com/doc/refman/4.1/en/insert-on-duplicate.html <http://dev.mysql.com/doc/refman/4.1/en/insert-on-duplicate.html>
I haven't seen any code that uses it. Is that habit or policy?
I always vote for using standard SQL unless there are very strong arguments for using a MySQL-only extension (or any database extension, really), unless it can be easily abstracted out. ..chrisxj
participants (3)
-
Chris Johnson -
Ken Rickard -
Khalid B