Link to home
Get AccessLog in
Avatar of Rodrigo Costa
Rodrigo CostaFlag for New Zealand

asked on

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

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?

Cheers!
ASKER CERTIFIED SOLUTION
Avatar of johanntagle
johanntagle
Flag of Philippines image

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access