UPDATE_COUNT_RUBY_STYLE

UPDATE_COUNT_RUBY_STYLE.rb

require 'rubygems'
require 'mysql'

mysql = Mysql.real_connect("localhost", "root", "pass", "db")
results = mysql.query("select wp_term_taxonomy.term_taxonomy_id as taxo_id, count(*) as count from wp_term_taxonomy
left join wp_term_relationships on wp_term_taxonomy.term_taxonomy_id = wp_term_relationships.term_taxonomy_id
where (wp_term_taxonomy.parent = 6 or wp_term_taxonomy.term_id = 6) group by term_id;")
results.each { |e| 
  mysql.query("UPDATE WP_TERM_TAXONOMY SET COUNT = #{e[1]} WHERE WP_TERM_TAXONOMY.TERM_TAXONOMY_ID = #{e[0]};")
   }

# results.each { |e| 
#   puts e[0] +"   ,   "+ e[1]
#   
#    }
 mysql.close