September 2, 2012 in Classic self-hosted technical help
in a ccs database (IP_ccs_custom_database_4) I have a field for each entry ( record_comments_queued ) that I need to change to 0 throughout all 130 entries.
I have never done something like this and wanted to try (I am using test database to do it) this way instead of d/l sql and doing find/replace.
would it be something based on this?
UPDATE table_name SET field1=new-value1, field2=new-value2 [WHERE Clause]
hmm I think I got it
UPDATE IP_ccs_custom_database_4 SET record_comments_queued=0
Yes that is the way to do it as long as you want all record_comments_queued columns set to zero.
yup, I tested on 2 databases before doing it on live and it did exactly as I needed.
thanks for confirming, I am very inexperienced with that,
This topic is now archived and is closed to further replies.
Started 1 hour ago
Started September 23
Started 2 hours ago