How to disable or enable comments on node types as Bulk

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 .