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.

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.
>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 (
>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 (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to