Miles,
The LIMIT works great with UPDATE too.
"Miles Thompson" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
> Come on, you're pushing SQL in directions it's not supposed to go! It is
> set oriented after all.
> So it's experimentation time. I've never tried, but as LIMIT works on a
> SELECT, try it on an update. And let us know what happened.
> Miles
>
> At 10:30 AM 8/2/01 +0200, elias wrote:
> >How can I update only N fields from the database?
> >
> >usually we do:
> >
> >UPDATE table1 SET field='VALUE' WHERE condition1
> >
> >now I want to update fields with a certain condition but only X fields
out N
> >total fields.
> >
> >ie:
> >
> >id value
> >--- -------
> >1 a
> >2 b
> >3 c
> >4 d
> >5 e
> >
> >how can i update such like:
> >UPDATE table1 SET {only 2 records} value='aa'
> >so I have any two fields now have the 'aa' value
> >
> >
> >
> >
> >
> >--
> >PHP General Mailing List (http://www.php.net/)
> >To unsubscribe, e-mail: [EMAIL PROTECTED]
> >For additional commands, e-mail: [EMAIL PROTECTED]
> >To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
