Re: How would I go about doing this?

[Felix Geerinckx]

Joey Gettings wrote:
> INSERT INTO ibrpg_quest VALUES (1, 'House Work',
> 'Clean your damn room scank', 1, 100, 'Coal', 30,
> 0, '', '', 0, 0, 100, 100, 30);
>
> After it's inserted, I want to remove it, or add
> something to it, or write over it.
>
> Say I wanted to change 'house work' to something
> else maybe.. 'after school work'.
>
> I'll get the duplicate error.

INSERT is for inserting new records

UPDATE is for changing records, eg like

UPDATE foo SET col = 'something else' WHERE id = 1

DELETE is for deleting records, eg like

DELETE from foo WHERE id = 1

--
felix