Nura111
asked on
How to delete from multiple Database
I want to perform a delete query as the next one
on different databases
DELETE FROM wp_posts WHERE post_type = "revision";
on different databases
DELETE FROM wp_posts WHERE post_type = "revision";
Last Comment
ASKER
yes all the databases are in one place can i
DELETE FROM <database name>.wp_posts WHERE post_type = "revision";
union <database name>.wp_posts
union <database name>.wp_posts
DELETE FROM <database name>.wp_posts WHERE post_type = "revision";
union <database name>.wp_posts
union <database name>.wp_posts
you are better off using the Class provided to you by Wordpress for interacting with the database
http://codex.wordpress.org/Function_Reference/wpdb_Class
More specifically, delete posts with wp_delete_post() or risk leaving behind things like comments and meta data.
http://codex.wordpress.org/Function_Reference/wp_delete_post
http://codex.wordpress.org/Function_Reference/wpdb_Class
More specifically, delete posts with wp_delete_post() or risk leaving behind things like comments and meta data.
http://codex.wordpress.org/Function_Reference/wp_delete_post
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Sorry, just realized you were trying to only delete revisions.
SQL
SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.
61K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
DELETE FROM <database name>.wp_posts WHERE post_type = "revision";