How to update a certain filed in all records for a table

Rodrigo Costa
Rodrigo Costa used Ask the Experts™
Hi folks I have a mySql table named tb1 which has several fields, one of which is an int(10) field called v1, I want to have all v1 fields for all records to be changed to 0.
How I would go about that?

Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2012
update tb1 set v1=0;

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial