Tags
Asked 3 years ago
1 Jul 2021
Views 224
Lesley

Lesley posted

How to empty a table without having DROP/TRUNCATE command

How to empty a table without having DROP/TRUNCATE command
david

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
Post Answer