While this question was asked more than 5 years ago and I don't know this facility existed in MySql back then but now if you use phpmyadmin you can simply open the database and then select the table(s) you want to truncate. At the bottom there is a drop down with many options listed. Open it and select Empty option under the heading Delete data or table. It takes you to the next page automatically where there is an option in checkbox called Enable foreign key checks. Just unselect it and press Yes button and the selected table(s) will be truncated. May be it internally runs the query suggested in user447951's answer. But it is very convenient to use from phpmyadmin interface.