How to update post type using phpmyadmin – wordpress

The codes below is shows how to change the all product post type into “post”.

Go to your cpanel and click your phpmyadmin .

Run this SQL below.

UPDATE  `wp_posts` SET  `post_type` =  'post' WHERE  `post_type` =  'product'