SQL Code to change Posts and Custom Post Types

I have two issues in WordPress 3.0+ where I need to make changes using SQL right in the MySQL DB.

One is to move posts or pages to a custom post type. I can’t figure out the structure that defines the post as a certain post type. I’d like to “migrate” the posts to a different custom post type.

The other is I screwed up and put in a bad custom post type name and capitalized it, thinking it was the label. So my links are broken. If I change the name I get a weird result where I can see the custom posts listed in the admin section but I can’t edit them. So I’d like to change the custom post type name in the post.

Has anybody used sql to do this right in the MySQL Database?