[SQL] Truncate multiple tables

+-----------------------------------------------------+
|               RETURN STRING SQL COMMAND             |
+-----------------------------------------------------+
SELECT CONCAT('TRUNCATE table ', TABLE_NAME, ';')
FROM information_schema.TABLES
WHERE TABLE_NAME IN (
    'player',
    'player_index',
    'player_deleted',
    'guild',
    'guild_war',
    'guild_grade',
    'guild_member',
    'guild_comment',
    'guild_war_bet',
    'guild_war_reservation',
    'item',
    'marriage',
    'horse_name',
    'dragonsoul_items',
    'change_empire',
    'affect'
);

+-----------------------------------------------------+
|               DIRECT SQL COMMAND                    |
+-----------------------------------------------------+
TRUNCATE TABLE player.player;
TRUNCATE TABLE player.player_index;
TRUNCATE TABLE player.player_deleted;
TRUNCATE TABLE player.guild;
TRUNCATE TABLE player.guild_war;
TRUNCATE TABLE player.guild_grade;
TRUNCATE TABLE player.guild_member;
TRUNCATE TABLE player.guild_comment;
TRUNCATE TABLE player.guild_war_bet;
TRUNCATE TABLE player.guild_war_reservation;
TRUNCATE TABLE player.marriage;
TRUNCATE TABLE player.item;
TRUNCATE TABLE player.quest;
TRUNCATE TABLE player.messenger_list;
TRUNCATE TABLE player.horse_name;
TRUNCATE TABLE player.dragonsoul_items;
TRUNCATE TABLE player.change_empire;
TRUNCATE TABLE player.affect;
TRUNCATE TABLE account.account;