October 26th, 2013, 11:47 AM
A strange Problem
As Cms I use Wordpress I want to export a whole category (windows 8) and I run the SQL command :
SELECT * FROM wp_posts
INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id)
WHERE (wp_term_taxonomy.term_id = 15
AND wp_term_taxonomy.taxonomy = 'category'
AND wp_posts.post_type = 'post'
AND wp_posts.post_status = 'publish');
I get the tables but then I can not export as SQL (there is no option) - Strange , is there a way to export only selected tables as SQL ?
Please look at the atachment and I did not understand why there is no export as SQL choice