I have a table in a database with about 2000 entries and 3 of the field in the database of all these entries need to be reset to their original value. How could I do this without manually going through all 2000 values and editing them?
- Managing Spam via IMAP
- Computer Virus On My Computer- Never!
- How To Determine The Origin Of Spam?
- 2008: Major Concerns for Network and Systems Administrators
- Spam Filtering
- How Anti Spam Software Works
- How Bayesian Spam Filters Work
- Google’s Tag To Remove Content Spamming
- What is the Point of Do-follow Links on Blogs?
- MBR_CHECKSUM_MISMATCH Hard Drive Error and Recovery
What do you mean with “reset”? What IS the original value? Are you talking about the default value? Then you can just use a UPDATE tblname SET columnname = ‘value’.
Give your additional info:
UPDATE tablename
SET field1 = ”
, field2 = ”
, field3 = ”
You can specify which rows you want to reset by adding a WHERE clause to the end:
UPDATE tablename
SET field1 = ”
, field2 = ”
, field3 = ”
WHERE field4 = ‘someValue’
UPDATE tablename SET field1=’value1′ WHERE field2=’value2′;