How to empty a table without having DROP/TRUNCATE command
How to empty a table without having DROP/TRUNCATE command
david
answered Jul 2 '21 00:00
by using PHPMyAdmin,
1. select the table
2. then go to operations
3. click on the "Empty the table (TRUNCATE)" and it will prompt for confirmation
You are about to TRUNCATE a complete table! Do you really want to execute "TRUNCATE `tablename`" ?
4. click on the ok will delete all the rows from the table