Re: MySql help #1

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: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net