Re: mysql question

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

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