How do I truncate tables in database sql

Avatar
  • Answered
I need to truncate all tables ( except 'sites' table) in my database
Avatar
Scott
Hello, Thank you for your question on how to truncate your MySQL database tables. You can do this via the phpMyAdmin tool within the cPanel. Visit the tool and select the database you want to work with. Then go to the SQL tab and enter the following SQL code for each table: TRUNCATE TABLE 'tablename'; Be sure to replace 'tablename' with the actual table name. Then click the GO button. After confirming your order, the tool will truncate the table. Kindest Regards, Scott M