Is it possible to truncate all table in mysql database ? what is query for that .
You can do this query:
select 'truncate table ' || table_name || ';' from INFORMATION_SCHEMA.TABLES;
Then save results to a script and run it.
Other possibility might be,
If you just run the query you will understand what I am trying to say.