How to use “TRUNCATE TABLE” MySQL statement?

As try today, truncate is WAY BETTER that DELETE, because DELETE broke the site, and trucate just empty the table, here is the working code : 

global $wpdb;

$wpdb->query('TRUNCATE TABLE wp_posts');

Related Posts:

  1. Rename a table in MySQL
  2. How should I tackle –secure-file-priv in MySQL?
  3. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  4. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  5. phpMyAdmin – Error > Incorrect format parameter?
  6. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  7. Using wpdb to connect to a separate database
  8. Checking if Database Table exists
  9. The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
  10. How to fetch Data in WordPress using MySQLi or $wpdb
  11. Connect to database using wordpress wp-config file
  12. wpdb->insert multiple record at once
  13. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  14. How to define composite keys with dbDelta()
  15. Is it possible to define two databases for one installation?
  16. Split WP install between 2 databases?
  17. Is altering a default WordPress database table update safe?
  18. Huge wp_options table
  19. “MySQL server has gone away” since update to 3.8
  20. Error establishing a database connection – with Debug Data
  21. How to execute mulitple statement SQL queries using $wpdb->query?
  22. Can I transfer a mysql database to another site?
  23. WordPress and automated MySQL backups to a different host
  24. Database with mixed collation (utf8mb4 & utf8_general_ci)
  25. MySQL Syntax Error upon restoring database from backup [closed]
  26. Help running a MySQL query to update all wp_#_options tables in a Multisite install
  27. Size article thumbnails and retrieve them directly from database
  28. Is it safe to convert tables from MyISAM to InnoDB?
  29. Emojis getting converted to “?”
  30. Migrating database / content of non-CMS site to WordPress
  31. Delete all post meta except featured image Using SQL
  32. How do I properly update the WordPress database password?
  33. wpdb_prepare with multiple or condition
  34. Adding new row to wp_post table
  35. WordPress Install and Database on separate hosting?
  36. WordPress mysql table double prefixes
  37. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  38. How do I get the posts within a certain year/date(with sql query)?
  39. Why do mass updates to post_content shows in front end, but not in edit screen?
  40. Error establishing database connection – high traffic?
  41. Using GROUP CONCAT in my-sql query with wp_usermeta table
  42. Create table from array with prepare
  43. How to prevent/delay MySQL connections when an object cache is used?
  44. Migrating from PDO using SQLite to clean new install using MySQL
  45. Call to undefined function get_user_meta() – trying to access data in MySQL from custom fields
  46. Duplicated site isn’t recognized as a site
  47. Have working sql query… trying to adjust it to use $wpdb
  48. Error establishing a database connection,
  49. Changing root password in PHPMyAdmin for WordPress Database when going live
  50. How to properly check if a table exists in WordPress Database using Show Tables Query
  51. Can’t update WordFence Options, clear data manually
  52. Changing between Local Host DB to Production DB and in reverse
  53. creating new field on mysql
  54. How and where is wordpress adding mySQL content to database?
  55. SQL query to set posts in bulk based on the post content
  56. Query Column of Specific ID from Database Table
  57. How can I detect right db type?
  58. How to create more than one new wpdb object?
  59. Buddypress avatar image in database [closed]
  60. Files on Localhost, Database on Server
  61. Remote database -> massive response time increase?
  62. Installing local to live WP into subdirectory
  63. Second ezSQL initialization for MSSQL
  64. Fetch a single row from a custom table for to a given ID
  65. Database create or redirect
  66. Getting “Error Establishing a Database Connection” on localhost in new Mac OSX Lion environment
  67. Cloning blog to localhost via WAMP
  68. MSQL database wp_postmeta has meta key tve_revision
  69. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  70. DB prefix not updating
  71. Recovery – Restore Database after moving folder location locally
  72. Replacing javascript link in WordPress database without getting mysql syntax errors
  73. How to edit custom table data in frontend
  74. local wordpress broke after changing URL
  75. “BS_” rows in postmeta table
  76. how to access 2nd Mysqli Database from different server for wordpress
  77. Error establishing a database connection – WordPress setup, everything else is working
  78. Exporting Post ID, Post Title, Primary Category and Primary Category ID
  79. How to map data on CSV to web pages?
  80. How to create index (sql) to a meta_key?
  81. Search and Replace in Windows XAMPP site
  82. WPCLI search and replace in a particlar site dir effect another site-dir
  83. How can i syn wordpress user table with a stand-alone php script?
  84. insert data from a form:: Warning Empty query mysqli::query()
  85. How can I get $wpdb to show MySQL warnings?
  86. mySQL database size large, but tables size less
  87. How To connect to the same WordPress database with different database user
  88. WordPress Database Posts Table query
  89. Hang Up Followed By Can’t select database
  90. How to extract some part of WordPress full source code
  91. Mysql Queries per Visit – Crazy High
  92. Why is converting my database to UTF-8 truncating entries?
  93. using same mysql user with many databases
  94. Why are my WordPress post queries so slow?
  95. Migrated to Namecheap, now Trouble with Database & wp-config [closed]
  96. export individual posts to text files or a single csv file
  97. Custom wordpress SQL statement for a website
  98. WordPress database connection failed, while mysql client is working [closed]
  99. Uploading to WordPress Database
  100. Have WordPress Use a Different Database for users

Leave a Comment