Reseting all fields
Moderator: General Moderators
-
InnerShadow
- Forum Commoner
- Posts: 37
- Joined: Thu Nov 10, 2005 10:44 pm
- Location: US
Reseting all fields
I was wondering if there was a easier way to reset all of the values in a table back to 0 instead of a very long set of UPDATE statements?
Or use "REPLACE (primary_key) values ('1');" where primary_key is the name of the primary key column. This would set all the fields to the default rather than 0 though. Should be a little faster than a delete and an insert.jshpro2 wrote:Do the fields have default values? Delete the row and create a new one with the same primary key