How do I truncate tables in database sql

InMotionFans

9 years ago
Answered

I need to truncate all tables ( except 'sites' table) in my database

Replies 1

Newest first
Newest first Oldest first

Scott

9 years ago

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

Reply Link