How to disable or enable comments on node types as Bulk

Warning message

JQuery Cycle must be installed in order to run the slideshow. Please go to Status Report for instructions.

If you have a content type where you have comments enabled/disabled and later you have decided to ON/OFF the comments but the problem is that if you have disabled/enabled the comments from the content type, it does not turn off/on the comments on existing nodes which you have made before. 

To turn off the comments you have to update 2 tables not just one . These are :

1. node
2. node_revision

So run the query :

UPDATE node_revision, node SET node_revision.comment = 0 WHERE node_revision.nid = node.nid AND node.type = "story";

Where comment values can be 0,1,2.

0 = no, 1 = closed (read only), 2 = open .