Truncating all tables in MySQL database

Asked May 26 '18 at 07:57

Active May 26 '18 at 08:10

Viewed 45 times

I want to execute this MySQL command:

mysql -Nse 'show tables' DATABASE_NAME | while read table; do mysql -e "truncate table $table" DATABASE_NAME; done

Whenever I do so, I receive the following error message:

'WHILE' is not recognized as an internal or external command, operable program or batch file.

edited May 26 '18 at 08:10

asked May 26 '18 at 07:57

ganesh kumar

Check the other answers in the duplicate topic, not just the accepted one. Btw your script is not for windows command line, this is why it does not run. – Shadow May 26 '18 at 08:04
But all are giving single table truncation. – ganesh kumar May 26 '18 at 08:07
But I need all tables truncation – ganesh kumar May 26 '18 at 08:07
Nope, the other solutions also truncate all tables. – Shadow May 26 '18 at 08:09
Thank You Friend.You have any other solution share with me. – ganesh kumar May 26 '18 at 08:13

0 Answers0