Jump to content

how do I do this sql queury/execute?

Featured Replies

Posted

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]

  • Author

hmm I think I got it

UPDATE IP_ccs_custom_database_4 SET record_comments_queued=0


seems to work on test database

Yes that is the way to do it as long as you want all record_comments_queued columns set to zero.

  • Author

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,

Archived

This topic is now archived and is closed to further replies.

Recently Browsing 0

  • No registered users viewing this page.