>> Is there a mysql command that will increment the value of a field in an >> existing row? I would think this would be pretty basic, but I can't seem >> to find anything in the online documentation. > >update t1 set f = f + 1
Unfortunately that will update all the records in the database. It's likely he would prefer to update a particular record via update t1 set f = f + 1 where id = 1234; Which will update only the record matching the id of 1234. Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]