How to delete post comments from the database via SQL statement?

Just run the following commands in your database

DELETE FROM wp_commentmeta;
DELETE FROM wp_comments;

If you changed the db prefix, the name might be foo_comments / foo_commentmeta or similar.

Related Posts:

  1. Why is Woocommerce writing in my wp_comment table?
  2. How to use a different database to list and manage comments in the backend
  3. Retrieve data from the database to table such as comments in the admin control panel
  4. SELECT SQL_CALC_FOUND_ROWS with wordpress search
  5. Counting user’s comments – efficient way?
  6. phpMyAdmin – Error > Incorrect format parameter?
  7. Difference between partition key, composite key and clustering key in Cassandra?
  8. How SID is different from Service name in Oracle tnsnames.ora
  9. What is a relation in database terminology?
  10. Why is my database import losing text widget data?
  11. Does dbDelta delete columns as well?
  12. Are There Any Plans for WordPress to Support Databases Other Than MySQL?
  13. Reset Post IDs to less than 64bit integer
  14. Insert data in database using form
  15. how can get database name in wordpress?
  16. Long option names fail silently?
  17. Upload files – total size limit – WordPress/Contact Form 7
  18. Relationship between performance and database size
  19. Why does WordPress rely on an fully qualified site_url with a 15-step plan for moving a site?
  20. WordPress and automated MySQL backups to a different host
  21. Scheduling posts in database
  22. Size article thumbnails and retrieve them directly from database
  23. Should I be able to run two different “close” code versions of wordpress with the same DB
  24. Need of separate security plugins for both root and subfolder sites WordPress?
  25. Escaping / encoding data before insert into a database?
  26. Get total number of comment of the posts written by an author
  27. how to store arrays into a database
  28. Error: SELECT SQL_CALC_FOUND_ROWS
  29. How can I create a Bible search engine via WordPress? [closed]
  30. Error establishing a database connection; After importing DB & Theme
  31. Where are WP_Errors Saved
  32. Get all images from this database table
  33. Delete transients in website
  34. Error establishing database connection – high traffic?
  35. Bulk-create posts from SQL database
  36. Populate dropdown from database
  37. I am switching laptops. I host my WP server through MAMP. I want to transfer [closed]
  38. wordpress ‘database update required’ loop after update
  39. Database Table for customer user
  40. Is there a solution to auto-post data to a WP post from a database
  41. How to Access wp_usermeta Data Immediately After a New User is Created
  42. Cleanup: best way to remove WooCommerce comments from the wp_comments table
  43. Logins from WP users table use on another page
  44. How to paginate information obtained from a query to a custom table?
  45. How can I show related posts from multiple separate installations
  46. Uknown meta entries in wp_postmeta
  47. Error establishing a database connection problem in xampp saver
  48. WordPress site URL changed; how to fix it without database access?
  49. I’m not able to get access to $wpdb [duplicate]
  50. Error establishing a database connection,
  51. Create table with dbDelta,can’t put any DEFAULT data
  52. WordPress database connection [closed]
  53. Changing between Local Host DB to Production DB and in reverse
  54. Post Views / Hit Counter Problem?
  55. Clear Terms from Taxonomy for Specific Post IDs?
  56. Options on how to Display member specific data from a MS SQL database
  57. Unkown meta_value in ACF
  58. Buddypress avatar image in database [closed]
  59. WordPress security [closed]
  60. How to split the WordPress database?
  61. $wpdb->get_var – What value is returned when zero records are found?
  62. Installing local to live WP into subdirectory
  63. WordPress SQL – How to Check for Category?
  64. SymmetricDS in dev + prod workflow?
  65. Fixing YARPP plugin FULLTEXT MySQL indexing
  66. Getting WordPress to work inside a rails 3 application
  67. Advantages of dbDelta
  68. Only allow user to access a link once a year, based on their joining date
  69. Error establishing a database connection in wordpress site , website not opening
  70. MSQL database wp_postmeta has meta key tve_revision
  71. Occasional Error Establishing a Database Connection
  72. Display user data in numbered list
  73. Removing old_slug and old_date from WordPress Database
  74. Help with $wpdb on custom code
  75. “BS_” rows in postmeta table
  76. Migrating meta_key and meta_value from old theme to new one
  77. How do I change several broken URLs in a several wordpress databases in the fastest way?
  78. How to rerieve comments and their replies from DB
  79. Optimize WP site for millions of posts
  80. I Want a More Concice Form of Data than an Array
  81. Duplicate database to roll back theme & content changes
  82. database error WordPress move from one hosting to other
  83. WordPress Migration – Issue with admin panel changes
  84. Select data from foreach loop and send it to wordpress database
  85. mySQL database size large, but tables size less
  86. Error establishing database connection error during first WordPress run
  87. Same DB for live and dev versions
  88. How much post meta data is too much?
  89. I have include wp-config, should I add global $wpdb also?
  90. Localize strings from db
  91. Can’t Install WordPress (local) Failed to open file wp-includes/wp-db.php
  92. version control for wordpress? (wordpress folder and database at same time)
  93. not saving post in wp_post wordpress database table
  94. Redirect Issue: WordPress database
  95. Install WordPress with SQL database
  96. Creating Job Tickets
  97. Best db table structure for users with many records
  98. How to stop WordPress from using utf8mb4_unicode_ci collation
  99. WP Multisite Users Not Linking
  100. Query a meta key using an array of values where the database value is a string