REPLACE shouldn't have given an error.  If REPLACE doesn't find a match 
on a unique index, it should just insert a new row, not cause an error.  
Perhaps it's the double-quotes?

alex

Craig White wrote:

>On Sun, 2005-02-27 at 23:14 -0700, Craig White wrote:
>  
>
>>no unique index in this particular table...
>>
>>mysql> REPLACE INTO horde_datatree_attributes attribute_value VALUES \
>>"Administrator" where datatree_id = '525';
>>
>>ERROR 1064: You have an error in your SQL syntax near 'attribute_value
>>VALUES "Administrator" where datatree_id = '525'' at line 1
>>
>>how do I do this?
>>    
>>
>----
>UPDATE - not REPLACE
>
>nevermind
>
>Thanks
>
>Craig
>
>---------------------------------------------------
>PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
>To subscribe, unsubscribe, or to change  you mail settings:
>http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>
>  
>

---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change  you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss