Advertisement
sorvani

update inktuta golems

Jan 31st, 2014
130
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.65 KB | None | 0 0
  1. CREATE TEMPORARY TABLE tmptable SELECT * FROM npc_types WHERE id = 296048;
  2. UPDATE tmptable SET id = 296002, `name` = 'a_clay_monolith' WHERE id = 296048;
  3. INSERT INTO tmptable SELECT * FROM npc_types WHERE id = 296048;
  4. UPDATE tmptable SET id = 296049, `name` = 'a_clay_monolith_' WHERE id = 296048;
  5. INSERT INTO tmptable SELECT * FROM npc_types WHERE id = 296048;
  6. UPDATE tmptable SET id = 296050, `name` = 'a_clay_monolith__' WHERE id = 296048;
  7. INSERT INTO tmptable SELECT * FROM npc_types WHERE id = 296048;
  8. UPDATE tmptable SET id = 296051, `name` = 'a_clay_monolith___' WHERE id = 296048;
  9. REPLACE INTO npc_types SELECT * FROM tmptable;
  10. DROP TABLE tmptable;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement