Tags
Asked 3 years ago
1 Jul 2021
Views 324
Margaret

Margaret posted

delete all record from table in mysql

delete all record from table in mysql
sec8

sec8
answered Jul 2 '21 00:00


by Truncate , you can empty the table or another word delete all record from table in Mysql

TRUNCATE `tablename`
sachin

sachin
answered Jul 2 '21 00:00

if you are using PHPMyAdmin , you can select the table and then go to operations and click on the "Empty the table (TRUNCATE)" and it will prompt
You are about to TRUNCATE a complete table! Do you really want to execute "TRUNCATE `tablename`" ?

and click on the ok will delete all the row from the table
Post Answer