You are here

drupalノードのコメントを一括で"closed"にするSQL

$ mysql -u root -p db_d7dev
mysql> show tables;
mysql> select * from node_type;
mysql> UPDATE node_revision, node SET node_revision.comment = 0 WHERE
 node_revision.nid = node.nid AND
 node.type = "article";