john henry bonham wrote:

If I want to update these day fields in this table:

day, date, month, year
-    1     August 2004
-    1     August 2004

I want on to be Sunday Lunchtime the other to be Sunday Evening. What query do I use that won't update both fields with the same data?


maybe something like this : UPDATE ... LIMIT 1;

so only the first one will be updated.

--
Philippe Poelvoorde
COS Trading Ltd.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to