patternMinor
There is no export as SQL option
Viewed 0 times
sqloptionthereexport
Problem
As CMS I use Wordpress. I want to export a whole category (windows 8) so I run the SQL command :
I get the tables but then I cannot export as SQL (there is no option) - strange. Is there a way to export only selected tables as SQL?
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 cannot export as SQL (there is no option) - strange. Is there a way to export only selected tables as SQL?
Solution
I get this effect only when applying a query.
A table, view, or other direct structure seems to export into SQL fine.
The SQL option seems is not available to a query result set, very sadly.
A table, view, or other direct structure seems to export into SQL fine.
The SQL option seems is not available to a query result set, very sadly.
Context
StackExchange Database Administrators Q#52269, answer score: 3
Revisions (0)
No revisions yet.