<div>
That should be one database at a time. In the same way I have answered you before, you can have one user account with permissions on several other database and from this account you can issue commands like this:<br />
<br />
DELETE FROM &lt;database name&gt;.wp_posts WHERE post_type = &quot;revision&quot;;
</div>


<div>
yes all the databases are in one place can i <br />
DELETE FROM &lt;database name&gt;.wp_posts WHERE post_type = &quot;revision&quot;;<br />
union &nbsp;&lt;database name&gt;.wp_posts<br />
union &nbsp; &lt;database name&gt;.wp_posts
</div>


<div>
you are better off using the Class provided to you by Wordpress for interacting with the database<br />
<br />
<a href="http://codex.wordpress.org/Function_Reference/wpdb_Class" rel="ugc">http://codex.wordpress.org/Function_Reference/wpdb_Class</a><br />
<br />
More specifically, delete posts with wp_delete_post() or risk leaving behind things like comments and meta data.<br />
<br />
<a href="http://codex.wordpress.org/Function_Reference/wp_delete_post" rel="ugc">http://codex.wordpress.org/Function_Reference/wp_delete_post</a><br />
<br />

</div>


<div>
Sorry, just realized you were trying to only delete revisions.
</div>


<div>
<div class="content wysiwyg-content">
I want to perform a delete query as the next one<br />
on different databases<br />
DELETE FROM wp_posts WHERE post_type = &quot;revision&quot;;
</div>
</div>


I want to perform a delete query as the next one
on different databases
DELETE FROM wp_posts WHERE post_type = "revision";

That should be one database at a time. In the same way I have answered you before, you can have one user account with permissions on several other database and from this account you can issue commands like this:

DELETE FROM &lt;database name&gt;.wp_posts WHERE post_type = &quot;revision&quot;;

yes all the databases are in one place can i 
DELETE FROM &lt;database name&gt;.wp_posts WHERE post_type = &quot;revision&quot;;
union  &lt;database name&gt;.wp_posts
union   &lt;database name&gt;.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



Sorry, just realized you were trying to only delete revisions.

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 = &quot;revision&quot;;

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

WordPress is a free and open-source content management system (CMS) based on PHP and MySQL for creating websites and blogs. Features include a plugin architecture, a template system and strong management, customization and search systems; through its dynamic presentation of content, webmasters have the flexibility to create websites easily.

WordPress

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.