how to remove category from database

It is done through the following query: 

delete from `wp_terms` where `term_id` in ( SELECT `term_id`
    FROM `wp_term_taxonomy`
    WHERE `taxonomy` = 'category' ) and `term_id` not like 1

This query deleted all the category except the default. Hope this helps to the others.

Related Posts:

  1. How To Find Out WordPress Category Table in MYSQL?
  2. How to convert regular categories to custom taxonomy?
  3. Deleting All tags except categories Wp database
  4. How Do I Merge Categories With phpMyAdmin
  5. Accessing WordPress MySQL Database via Data Connection in Visual Studio 2010 using C#
  6. Wacky taxonomy in wordpress
  7. Array: What is this value based on?
  8. How to list all categories and their IDs using SQL query?
  9. Deleting a category from WordPress admin does it remove it completely from the database?
  10. How Do I Delete WordPress Posts Older Than 400 Days, From A WordPress Category
  11. How to store category and tags separatly on wordpress?
  12. Create categories manually in database
  13. Search Replace Database ONLY for posts of certain category?
  14. Backend – Categories and Menus conflicts
  15. add an image field to wordpress category
  16. Fetch all categories from database
  17. Get posts from sites in Multisite?
  18. How to create a custom sort for WordPress categories
  19. Hook when category is added to post
  20. How to add the category ID to admin page
  21. Multiple Domain Names – One WP Install (non-Multisite) – Default Each Domain name to Category Archive
  22. WordPress remove separator from last item in wp_list_categories
  23. Filter categories using tags
  24. Sticky posts on home page, search, tag and archives without plugin
  25. Need help adding custom field to category
  26. Show Post from parent category (custom taxonomy) ONLY!
  27. How to display a list of categories
  28. One WordPress Install, Two Categories. Each Category Gets a Domain
  29. Create single.php for specific category by category id
  30. is_category in pre_get_posts results in php notices
  31. Filtering Children of the “uncategorized” Category out of the Loop?
  32. How to make all posts in a category “unsticky”?
  33. How do I get the total number of categories in a list of search results?
  34. Update wordpress post terms programatically
  35. advanced custom field Show field in special categry page [closed]
  36. Display products for a category, sorted by post_excerpt
  37. Creating archive pages for children categories
  38. “NOT ONLY IN” taxonomy query operator?
  39. How do you bulk remove a category from posts?
  40. How to remove the “+Add Category” button from the Category metabox?
  41. Show recent posts from one category on a non-WP site
  42. Omit specific product categories from WooCommerce shortcode
  43. Inserting Category programmatically
  44. Category-slug.php not being used
  45. Additional form options based on category selected not working
  46. Pagination for category slug returns 404 when page >= 2
  47. Display category-specific comments in sidebar
  48. Paging not working in category.php
  49. Display list of categories filtered by date?
  50. Drop posts from categories in MySql
  51. Exclude category by slug in pre_get_posts?
  52. add slug beside name in Admin Category Checklists
  53. How to show 5 posts from specific category on related page?
  54. Exclude category from related post
  55. Post belonging to many categories
  56. how do I use the walker class to display categories in their correct heirarchy?
  57. How can you access category information from a theme?
  58. Filter WooCommerce archive pages by an additional category
  59. WP 4.7 in_category change?
  60. display category list year wise in wordpress
  61. Display subcategories in dropdown
  62. Illegal string offset ‘taxonomy’ in
  63. Category Page Template – Can’t get category ID
  64. Are term_taxonomy_id and term_id the same? [duplicate]
  65. Display all sub category but one
  66. Filter Category Loop Dynamically
  67. SQL query to get posts from multiple categories but not in a category
  68. Can each user have only access to a private area (his own categories and posts)?
  69. WP Category Meta plugin fix? [closed]
  70. WP SQL Categories Export and Import
  71. How to display WooCommerce category image in my category page banner as a background?
  72. Why are my newly added categories not showing up when creating a post?
  73. WordPress Default Category and Custom Taxonomy Selected Attribute not Working After Searched in wp_dropdown_categories Array
  74. Order wp_dropdown_categories by ASC or DESC
  75. Add filter for specific category only
  76. How to exclude a category returned by get_categories from function.php?
  77. Displaying only selected categories
  78. How to get get_categories()’s ‘hide_empty’ argument to work with global year var in the archive template?
  79. Getting a sub category based on a category name
  80. How to display only sticky posts on category pages?
  81. Conditional statement: if is_category, append at the end of page
  82. I have many different products on my website how can I get them to display under specific categories?
  83. Help with SQL query, how to add taxonomie terms with value stored in options?
  84. /blog/ permalink prefix causes category pages to 404
  85. How to create an array with category ids order by the one that has the most recent post
  86. Pass list of categories to JS
  87. WP url to get rss with full text of post
  88. Display Referring Category on single post?
  89. Conditional statements based on custom meta value in category archives
  90. Placement of categories
  91. Paginating a list of all posts collected by category titles
  92. Display deepest post category, when post have multiple categories
  93. Paginate WordPress Category Pages
  94. Get a list of post titles and links from yootheme master theme
  95. How to structure Multisite sites into categories?
  96. Page permalink rewrite
  97. Excluding cateory not working on my site. how to solve this? [closed]
  98. Get all first images of posts in same category
  99. Woocommerce Force the category choice before creating new product? [duplicate]
  100. Replace category titles inside RSS feed
techhipbettruvabetnorabahisbahis forumuedueduseduseduedueduseduseduedusedus