Stored Prod....

[xAdrianRonsten]

      --weapon
      SET @itemid = @itemid + 1
      INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 4000, 0, 129, 1, 12, 12, 0, 8, 0, 0, 0, 0, 0, 8, 8 )

this add the item with index 4000 to user but what if i wanna remove a item. what do i write instead of INSERT INTO ?

[MentaL]

[Arturasult]

DELETE FROM Item WHERE [IID] = @itemid