LoginSignup
1
1

More than 5 years have passed since last update.

MTのMYSQLでタグの回数をCSV出力

Last updated at Posted at 2012-11-21
qiita
SELECT t.tag_name, COUNT(t.tag_name) AS count 
FROM mt_tag AS t, mt_objecttag AS o 
WHERE t.tag_id = o.objecttag_tag_id AND o.objecttag_object_datasource = "entry" AND o.objecttag_blog_id = 1 
GROUP BY t.tag_name HAVING COUNT(t.tag_name) > 0 
INTO OUTFILE "ファイル名.csv" 
FIELDS TERMINATED BY ",";

参考URL
http://keywordsmemo.blogspot.jp/2011/02/movable-type.html
http://phpjavascriptroom.com/?t=mysql&p=join
http://sasuke.main.jp/sqlcsv.html
http://yoshiomemo.blog115.fc2.com/blog-entry-32.html
http://kawama.jp/archives/2009/11/mysql_7.html

1
1
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
1
1