database entries query

[vitus0123456]

hi guys, how would you do multiple number change in a query.
for example, I want to change an entry in the augment.sql as follow:

PRIMARY KEY (augmentId,multiplier,modId,isPet,petType)
INSERT INTO augments VALUES (327,0,0,0,0,0); -- Weapon skill damage+1% (unsure if this is all hits damage or first hit damage, leaving blank until determined)

I would like to change the italic above to:
INSERT INTO augments VALUES (327,0,840,1,0,0);

any help would be much appreciated.

[vitus0123456]

for now, i'm trying this:
UPDATE augments SET modId = 840 WHERE augmentId = "327";
UPDATE augments SET value = 1 WHERE augmentId = "327";

any better way to do it would be appreciated

[TeoTwawki]

REPLACE INTO `augements` VALUES (327,0,840,1,0,0);

this only works in table sthat have primary keys (which this one does).

For tables without primary keys (for example mob drops) its possible to delete the row then do a normal INSERT statement.

[vitus0123456]

thank you. thank you