SHARE
TWEET

Untitled

a guest Jun 19th, 2017 47 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- Removing common weapon elements
  2. DELETE
  3. FROM
  4.     item_attributes
  5. WHERE
  6.     itemId IN
  7.     (
  8.         SELECT
  9.             object_id
  10.         FROM
  11.             items
  12.         WHERE
  13.             item_id IN
  14.             (
  15.                 SELECT
  16.                     item_id
  17.                 FROM
  18.                     weapon
  19.                 WHERE
  20.                     name LIKE "Common Item%"
  21.             )
  22.     )
  23. ;
  24. -- Removing common armor elements
  25. DELETE
  26. FROM
  27.     item_attributes
  28. WHERE
  29.     itemId IN
  30.     (
  31.         SELECT
  32.             object_id
  33.         FROM
  34.             items
  35.         WHERE
  36.             item_id IN
  37.             (
  38.                 SELECT
  39.                     item_id
  40.                 FROM
  41.                     armor
  42.                 WHERE
  43.                     name LIKE "Common Item%"
  44.             )
  45.     )
  46. ;
RAW Paste Data
Want to get better at SQL?
Learn to code SQL in 2017
Pastebin PRO Summer Special!
Get 40% OFF on Pastebin PRO accounts!
Top