It was missing a semi-colon after creature_model_info, try this:
Code:
TRUNCATE TABLE creature;
TRUNCATE TABLE creature_ai_scripts;
TRUNCATE TABLE creature_ai_texts;
TRUNCATE TABLE creature_battleground;
TRUNCATE TABLE creature_involvedrelation;
TRUNCATE TABLE creature_loot_template;
TRUNCATE TABLE creature_model_info;
TRUNCATE TABLE creature_model_race;
TRUNCATE TABLE creature_movement;
TRUNCATE TABLE creature_movement_scripts;
TRUNCATE TABLE creature_movement_template;
TRUNCATE TABLE creature_onkill_reputation;
TRUNCATE TABLE creature_questrelation;
TRUNCATE TABLE creature_respawn;
TRUNCATE TABLE creature_template;
TRUNCATE TABLE creature_template_addon;
TRUNCATE TABLE npc_gossip;
TRUNCATE TABLE npc_spellclick_spells;
TRUNCATE TABLE npc_text;
TRUNCATE TABLE npc_trainer;
TRUNCATE TABLE npc_vendor;