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
(text/plain)