On Tue, 14 Sep 2004 01:07:53 -0400, Seth <[EMAIL PROTECTED]> wrote: > I am fairly new to MySQL and I have been trying to form a way to have select rows > numbers put back to 0, sort of like a reset in some rows of the table. > > The table is ladder_1 and I am trying to have the fields > rank,lrank,wins,loss,games,percent,streak,points,kills on all the rows updated back > to 0 as a number on all rows.
I think you're looking for: update ladder_1 set rank = 0, lrank = 0, wins = 0, et al. You can specify a where clause on an update if you don't want to update absolutely everything. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
