Please post the entire contents of SHOW CREATE TABLE for this table and we will have enough information to answer your question.
Shawn Green Database Administrator Unimin Corporation - Spruce Pine [EMAIL PROTECTED] wrote on 08/13/2004 09:48:21 AM: > 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? > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >