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]
