Craig White wrote:

>perhaps the problem was that the table didn't have any unique indexes.
>
>anyway, update did the trick I needed...
>
>mysql> UPDATE horde_datatree_attributes SET attribute_value = \
>"Administrator" where datatree_id = "525";
>
>Thanks
>
>Craig
>
>  
>
I figured it out.  The error is because you have a syntax error in the 
REPLACE query.  It takes the same form as INSERT queries, not UPDATE 
queries.

This would work, regardless of indicies : "REPLACE INTO 
horde_datatree_attributes (datatree_id, attribute_value) VALUES (525, 
'Administrator)"

But it probably isn't what you want.  If there's no unique index, it 
would insert a new row with the supplied values - and it sounds like an 
UPDATE is really what you want.

I just wanted to point out that REPLACE doesn't care if there's a unique 
index or not - it just has special rules to follow if one does exist.

thanks,
alex

>On Mon, 2005-02-28 at 08:38 -0700, Alex Dean wrote:
>  
>
>>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
>>    
>>
>
>---------------------------------------------------
>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