can "simulate" the "UPSERT". :)
Thanking in advance.
Regards,
Tan Shao Yi
- Original Message -
From: Heikki Tuuri
Date: February 16 2004 9:12am
Subject: Re: REPLACE INTO and CASCADEs.
Hi!
The REPLACE + FOREIGN KEY behavior indeed changed between 4.0.17 ->
Hi!
The REPLACE + FOREIGN KEY behavior indeed changed between 4.0.17 -> 4.0.18,
because the old behavior was wrong, according to the MySQL manual:
"
Fixed a bug: MySQL should not let REPLACE to perform internally an UPDATE if
the table is referenced by a FOREIGN KEY. The MySQL manual states that
