Code LOL

The best way to understand the tables is to look at the WordPress Databae Design page, so you are aware of the dependencies.  I wanted a nearly clean copy of WordPress, so I executed the following SQL statements:

delete from wp_comments;
delete from wp_links;
delete from wp_posts;
delete from wp_postmeta;
update wp_term_taxonomy set count = 0 where 1 = 1;
delete from wp_term_relationships;

This deletes all comments, links, posts, post metadata, resets the count for the tags/categories/links to 0, and deletes the relationships.  I had to delete more than comments and posts, otherwise the tables would be in an inconsistent state.  For example, it may end up showing more than 1 post under a certain tag when all posts have been removed.   Thus, that explains why I had to set count to 0 for wp_term_taxonomy and remove all the links.