Query to remove all augs

**Kingly_Krab** · #1 01-30-2015, 10:37 PM

I would highly recommend making a backup before running this:

Code:

DELETE FROM `items` WHERE `itemtype` = '54';

epilz · #2 01-30-2015, 11:01 PM

this is what I got.

Code:

/* Affected rows: 8,966  Found rows: 0  Warnings: 0  Duration for 1 query: 0.687 sec. */

Bohbo · #3 01-31-2015, 04:35 PM

Quote:

Originally Posted by epilz

this is what I got.

Code:

/* Affected rows: 8,966  Found rows: 0  Warnings: 0  Duration for 1 query: 0.687 sec. */

That means 8966 rows (or augment typed items 54 in this case) got deleted. So they should be totally removed.