On 11/11/05, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
> Guys,
>
> > I understand you well... what i was trying to say is that i prefer
> > MERGE (standard SQL command) to be done because the functionally it
> > has (basically a merge of two tables) seems to me to be more usefull
> > than REPLACE (MySql Command)...
>
> But even REPLACE requires predicate locking. There's no real way to get
> around it.
>
> --Josh
>
why? seems that REPLACE only work if there are at least one row matching...
--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)