Dmacleo Posted September 2, 2012 Share Posted September 2, 2012 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] Link to comment Share on other sites More sharing options...
Dmacleo Posted September 2, 2012 Author Share Posted September 2, 2012 hmm I think I got itUPDATE IP_ccs_custom_database_4 SET record_comments_queued=0 seems to work on test database Link to comment Share on other sites More sharing options...
Royzee Posted September 2, 2012 Share Posted September 2, 2012 Yes that is the way to do it as long as you want all record_comments_queued columns set to zero. Link to comment Share on other sites More sharing options...
Dmacleo Posted September 2, 2012 Author Share Posted September 2, 2012 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, Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.