Use the following procedure to perform the truncate table operation using the MySQL CLI:
- Log in to your hosting account using SSH:
mysql -u [username] -p [database_name)For example:
mysql -u johndoe -p data_mysite
- Enter your password.
truncate table [table_name]
For the complete MySQL documentation, refer to the MySQL website.