list-truncates.sql

# Code below will show the truncate code for all tables in desired schema
SELECT
    Concat('TRUNCATE TABLE ', TABLE_NAME, ';')
FROM
    INFORMATION_SCHEMA.TABLES
WHERE
    table_schema = 'your-table';

# disabling foreign checks for a while
SET FOREIGN_KEY_CHECKS=0;
# put the result of select above here
SET FOREIGN_KEY_CHECKS=1;